Re: Join query on 1M row table slow - Mailing list pgsql-general

From scott.marlowe
Subject Re: Join query on 1M row table slow
Date
Msg-id Pine.LNX.4.33.0402101520400.29717-100000@css120.ihs.com
Whole thread Raw
In response to Re: Join query on 1M row table slow  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
On Tue, 10 Feb 2004, CSN wrote:

>
> --- "scott.marlowe" <scott.marlowe@ihs.com> wrote:
> > >What's weird is that when the same query
> > is
> > > executed again, it seems much faster - some sort
> > of
> > > caching maybe?>
> >
> > Yep.  Exactly.
>
> Really? Where can I RTFM about it?

Not sure.  Basically, your kernel should be caching a fair bit.  See what
top says about cache and buffer size.  If you've got a big enough kernel
buffer, and the table gets hit often enough, it should stay in kernel
memory.


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Join query on 1M row table slow
Next
From: CSN
Date:
Subject: Re: Join query on 1M row table slow