Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?

Поиск
Список
Период
Сортировка
Искать
От
Jeff Janes
Тема
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Дата
Msg-id
CAMkU=1wJ7ciYC_qX1es8oGQSc08jM7Vpvg52ahxU39ao93EC0w@mail.gmail.com
Ответ на
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? (Stefan Keller)
Список
Дерево обсуждения
PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Cédric Villemain <cedric@2ndquadrant.fr>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andy Colson <andy@squeakycode.net>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andy Colson <andy@squeakycode.net>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire <klaussfreire@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andrew Dunstan <andrew@dunslane.net>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire <klaussfreire@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Peter van Hardenberg <pvh@pvh.ca>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire <klaussfreire@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andrew Dunstan <andrew@dunslane.net>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Scott Marlowe <scott.marlowe@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire <klaussfreire@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller <sfkeller@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stephen Frost <sfrost@snowman.net>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes <jeff.janes@gmail.com>
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Thomas Kellerer <spam_eater@gmx.net> 
On Sun, Feb 26, 2012 at 12:37 PM, Stefan Keller  wrote:
> 2012/2/26 Andy Colson  wrote:
>>>> How about after you load the data, vacuum freeze it, then do something
>>>> like:
>>>>
>>>> SELECT count(*) FROM osm_point WHERE tags @>  'tourism=>junk'
>>>>
>>>> -Andy
>>>
>>>
>>> That good idea is what I proposed elsewhere on one of the PG lists and
>>> got told that this does'nt help.
>>>
> ...
>> I don't buy that.  Did you test it?  Who/where did you hear this?  And...
>> how long does it take after you replace the entire table until things are
>> good and cached?  One or two queries?
>>
>> After a complete reload of the data, do you vacuum freeze it?
>
> Yes.
>
>> After a complete reload of the data, how long until its fast?
>
> Just after the second query. You can try it yourself online here:
> http://bit.ly/A8duyB

The second instance of the exact same query is fast.  How long until
all similar but not identical queries are fast?

Cheers,

Jeff
В списке pgsql-performance по дате отправления
Предыдущее
От: Jeff Janes
Дата:
Следующее
От: Tomas Vondra
Дата:
FAQ