Re: [PERFORM] Testing Sandforce SSD

2010-07-25 Thread Yeb Havinga
Yeb Havinga wrote: 8GB DDR2 something.. (lots of details removed) Graph of TPS at http://tinypic.com/r/b96aup/3 and latency at http://tinypic.com/r/x5e846/3 Thanks http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm for the gnuplot and psql scripts! -- Sent via pgsql-performan

Re: [PERFORM] Testing Sandforce SSD

2010-07-25 Thread Yeb Havinga
Greg Smith wrote: Put it on ext3, toggle on noatime, and move on to testing. The overhead of the metadata writes is the least of the problems when doing write-heavy stuff on Linux. I ran a pgbench run and power failure test during pgbench with a 3 year old computer 8GB DDR ? Intel Core 2 duo

Re: [PERFORM] Pooling in Core WAS: Need help in performance tuning.

2010-07-25 Thread Dimitri Fontaine
Craig Ringer writes: > 9.0 has application_name to let apps identify themselves. Perhaps a > "pooled_client_ip", to be set by a pooler rather than the app, could be > added to address this problem in a way that can be used by all poolers > new and existing, not just any new in-core pooling system.

Re: [PERFORM] Using more tha one index per table

2010-07-25 Thread Dimitri Fontaine
Greg Smith writes: > Craig James wrote: >> By using "current" and encouraging people to link to that, we could >> quickly change the Google pagerank so that a search for Postgres would >> turn up the most-recent version of documentation. > > How do you propose to encourage people to do that? Wh