Re: Highload website database architecture

2006-12-04 Thread Joseph Heck
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 ef

Highload website database architecture

2006-12-01 Thread a
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 w