The postgres mailing list or IRC channel would generally be better, but here's some numbers that I got from last year's OSCON in Portland, OR from the Postgres geeks there.
For a 2Gb RAM machine, a good starting rule of thumb: shared_buffers = 25000 work_mem = 16384 maintenance_work_mem = 16384 effective_cache_size = 82500 Those are just magic numbers I had in my notebook from that session, but maybe they'll be useful for you. -joe On 12/1/06, a <[EMAIL PROTECTED]> wrote: > > > Hi, > > I am building a web app backed by database postgresql and currently the > site is under a humongous torrent of hits. I have a question regarding > the database backend config. > > The database folder has a file called postgresql.cons where we can > specify no of active connections to the database -N which is currently > 1024 and also specify the shared buffers. Is there any thumbrule in > deciding the -N and also the no of shared buffers for my config of 4 > frontend servers and 1 database backend server. There is no global or > memcached mechanisms in use. > > Any pointers would be greatly appreciated. > > Thanx > a > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
