Postgres Pro
Downloads
Home   >   mailing lists

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

From CSN
Subject Re: Join query on 1M row table slow
Date
Msg-id 20040210220449.49556.qmail@web40614.mail.yahoo.com
Whole thread Raw
In response to Re: Join query on 1M row table slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Join query on 1M row table slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
--- "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?

CSN


__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

pgsql-general by date:

Previous
From: CSN
Date:
Subject: Re: Join query on 1M row table slow
Next
From: "Ed L."
Date:
Subject: Re: DB cache size strategies