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

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: large tables and simple "= constant" queries using indexes
Дата
Msg-id 47FE3DC7.4010700@gmail.com
обсуждение исходный текст
Ответ на Re: large tables and simple "= constant" queries using indexes  (John Beaver <john.e.beaver@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления: