On Thu, May 7, 2009 at 12:53 PM, David Blewett <david@xxxxxxxxxxxxxxxx> wrote: > 1. http://dpaste.com/hold/41842/ > 2. http://explain.depesz.com/s/Wg > 3. http://explain.depesz.com/s/1s > 4. http://dpaste.com/hold/41846/ Forgot to mention that I'm using Postgres 8.3.6 on linux 2.6.24. Shared buffers are set to 1GB, effective_cache_size is set to 3GB. Server has 6GB RAM, running on a SCSI 4-disk RAID10. David Blewett -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
