Re: [PERFORM] "large" spam tables and performance: postgres memory parameters

2010-01-07 Thread Stephen Frost
* Gary Warner (g...@cis.uab.edu) wrote: > - if you have 8 pentium cores, 12GB of RAM and "infinite" diskspace, what > sorts of memory settings would you have in your start up tables? If the PG database is the only thing on the system, I'd probably go with something like: shared_buffers = 4GB te

Re: [PERFORM] "large" spam tables and performance: postgres memory parameters

2010-01-07 Thread Scott Marlowe
On Thu, Jan 7, 2010 at 8:23 AM, Gary Warner wrote: > Hello, > > I've been lurking on this list a couple weeks now, and have asked some "side > questions" to some of the list members, who have been gracious, and helpful, > and encouraged me to just dive in and participate on the list. > > I'll no

Re: [PERFORM] "large" spam tables and performance: postgres memory parameters

2010-01-07 Thread Kevin Grittner
Welcome out of the shadows, Gary! ;-) Gary Warner wrote: > My biggest question mark there really has to do with how many > users I have and how that might alter the results. In benchmarks I've run with our software load, I've found that I get best throughput when I use a connection pool whic