Skip site navigation (1) Skip section navigation (2)

Re: large tables and simple "= constant" queries using indexes

From: Gaetano Mendola <mendola(at)gmail(dot)com>
To: John Beaver <john(dot)e(dot)beaver(at)gmail(dot)com>
Subject: Re: large tables and simple "= constant" queries using indexes
Date: 2008-04-10 16:18:15
Message-ID: 47FE3DC7.4010700@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: John BeaverDate: 2008-04-10 16:37:45
Subject: Re: large tables and simple "= constant" queries using indexes
Previous:From: Erik JonesDate: 2008-04-10 15:02:48
Subject: Re: large tables and simple "= constant" queries using indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group