On Mon, Mar 24, 2008 at 3:37 PM, Andreas Kretschmer
<[EMAIL PROTECTED]> wrote:
> petchimuthu lingam <[EMAIL PROTECTED]> schrieb:
>
>
> > Hi friends,
> >
> > I am using postgresql 8.1, I have shared_buffers = 5, now i execute the
> > query, it takes 18 seconds to do sequential scan, when i r
petchimuthu lingam <[EMAIL PROTECTED]> schrieb:
> Hi friends,
>
> I am using postgresql 8.1, I have shared_buffers = 5, now i execute the
> query, it takes 18 seconds to do sequential scan, when i reduced to 5000, it
> takes one 10 seconds, Why.
Wild guess: the second time the data are in th
Hi friends,
I am using postgresql 8.1, I have shared_buffers = 5, 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
