increasing shared buffer slow downs query performance.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: increasing shared buffer slow downs query performance.
From: "petchimuthu lingam" <spmlingam@xxxxxxxxx>
Date: Mon, 24 Mar 2008 14:57:59 +0530

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

Follow-Ups:
- Re: increasing shared buffer slow downs query performance.
  - From: Andreas Kretschmer

Prev by Date: Re: slow pg_connect()
Next by Date: Re: increasing shared buffer slow downs query performance.
Previous by thread: Turn correlated in subquery into join
Next by thread: Re: increasing shared buffer slow downs query performance.
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux