Re: [Sqlgrey-users] Congratulations & PostgreSQL issue

[Karl O. P. <ko...@me...>]

On Wed, 12 Aug 2015 00:28:30 +0200
Lionel Bouton <lio...@bo...> wrote:

> Le 11/08/2015 22:26, Jean-Michel Pouré - GOOZE a écrit :

> > There might be modifications needed to stand "huge" loads under
> > PostgreSQL. For example, I think of as much as 10.000 queries per
> > second. This does not happen very often, I agree.
> 
> In theory you should be able to reach these levels with PostgreSQL
> easily even with write-intensive situations like SPAM storms if you
> use enterprise level SSD to store your database. I've not tested
> SQLgrey itself at these levels though (you may need to distribute the
> workload on multiple instances).

You could always throw hardware at it.  The latest Postgres
(at least) has multi-master capability.



Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein