Postgres Pro
Downloads
Home   >   mailing lists

increasing shared buffer slow downs query performance. - Mailing list pgsql-performance

From petchimuthu lingam
Subject increasing shared buffer slow downs query performance.
Date
Msg-id cd233fc30803240227u7507f0c7wf67bb313c61f8a7@mail.gmail.com
Whole thread Raw
Responses Re: increasing shared buffer slow downs query performance.
List pgsql-performance
Tree view
Hi friends,

I am using postgresql 8.1, I have shared_buffers = 50000, now i execute the query, it takes 18 seconds to do sequential scan, when i reduced to 5000, it takes one 10 seconds, Why.

Can anyone explain what is the reason, ( any other configuration is needed in postgresql.conf)

--
With Best Regards,
Petchimuthulingam S

pgsql-performance by date:

Previous
From: "vincent"
Date:
Subject: Re: slow pg_connect()
Next
From: Andreas Kretschmer
Date:
Subject: Re: increasing shared buffer slow downs query performance.