Re: Optimizing further

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ken Williams <ken(at)mathforum(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing further
Date: 2002-06-14 02:35:29
Message-ID: 1988.1024022129@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ken Williams <ken(at)mathforum(dot)org> writes:
> When I run the query, it takes a really long time (10 seconds)
> the first time I execute it, and then returns instantly the
> second time.

That sounds like a caching issue. How much RAM do you have,
what have you got shared_buffers set to, etc?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Williams 2002-06-14 02:45:50 Re: Optimizing further
Previous Message Bruce Momjian 2002-06-14 02:35:10 Re: read this and puke