Postgres Pro
Downloads
Home   >   mailing lists

Re: large tables and simple "= constant" queries using indexes - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: large tables and simple "= constant" queries using indexes
Date
Msg-id 47FE3DC7.4010700@gmail.com
Whole thread Raw
In response to Re: large tables and simple "= constant" queries using indexes  (John Beaver <john.e.beaver@gmail.com>)
List pgsql-performance
Tree view 
John Beaver wrote:

> - Trying the same constant a second time gave an instantaneous result,
> I'm guessing because of query/result caching.

AFAIK no query/result caching is in place in postgres, what you are experiencing
is OS disk/memory caching.


Regards
Gaetano Mendola

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Looking for bottleneck during load test
Next
From: Rajashri Tupe
Date:
Subject: Re: Views and functions returning sets of records