On Friday, June 14, 2002, at 12:35 PM, Tom Lane wrote:
> Ken Williams <ken@mathforum.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?
Hi Tom,
'top' reports 1024M of real memory, with 819M virtual. shared_buffers
is currently set to 64. Is there some information about the table
itself or the index that would be helpful to know?
-Ken