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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
