On 1/10/08, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Jan 10, 2008 12:33 PM, Sim Zacks <sim@xxxxxxxxxxxxxx> wrote: > > > Perhaps a suboptimal plan is picked due to configuration issues, e.g. > > > memory constraints? Could you post your postgresql.conf as well? > > > > Below is the postgresql.conf file for 8.2.4. The server has 2 GB of RAM and it was not maxed out when I ran the query. > > As I mentioned, I tried running both 8.0.11 and 8.2.4 on the same hardware, so that I would see if it was a difference in the hardware or the database. > > > > # ----------------------------- > > # PostgreSQL configuration file > > # ----------------------------- > > > shared_buffers = 24MB# min 128kB or max_connections*16kB > That's really low. Try setting it to something a bit more aggressive, > say 100MB to 500MB. On a machine with 2 Gig ram, that's a pretty > reasonable range. > > > #work_mem = 1MB# min 64kB > Try setting this a little higher, say 16 to 32 Megs. > Also, effective_cache_size should be about 1GB on a server with 2GB ram. See <http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm> for a quick, up-to-date, intro to postgres tuning. Kind regards, Isak ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
