On Wed, Feb 25, 2009 at 4:32 PM, Farhan Husain <russoue@xxxxxxxxx> wrote: > On Wed, Feb 25, 2009 at 3:30 PM, Robert Haas <robertmhaas@xxxxxxxxx> wrote: >> On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain <russoue@xxxxxxxxx> wrote: >> > Initially, it was the default value (32MB). Later I played with that >> > value >> > thinking that it might improve the performance. But all the values >> > resulted >> > in same amount of time. >> >> Well, if you set it back to what we consider to be a reasonable value, >> rerun EXPLAIN ANALYZE, and post that plan, it might help us tell you >> what to do next. >> >> ...Robert > > Right now I am running the query again with 32MB work_mem. It is taking a > long time as before. However, I have kept the following values unchanged: > > shared_buffers = 32MB # min 128kB or max_connections*16kB > > temp_buffers = 1024MB # min 800kB > > Do you think I should change them to something else? It would probably be good to change them, but I don't think it's going to fix the problem you're having with this query. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
