Re: [PERFORM] Speeding up JSON + TSQUERY + GIN

Поиск
Список
Период
Сортировка
От Sven R. Kunze
Тема Re: [PERFORM] Speeding up JSON + TSQUERY + GIN
Дата
Msg-id b10df25c-c796-2cf0-60c0-040c31bc99a9@mail.de
обсуждение исходный текст
Ответ на Re: [PERFORM] Speeding up JSON + TSQUERY + GIN  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [PERFORM] Speeding up JSON + TSQUERY + GIN
Список pgsql-performance
On 28.02.2017 17:49, Jeff Janes wrote:
Oh.  In my hands, it works very well.  I get 70 seconds to do the {age: 20} query from pure cold caches, versus 1.4 seconds from cold caches which was followed by pg_prewarm('docs','prefetch').

How much RAM do you have?  Maybe you don't have enough to hold the table in RAM.  What kind of IO system?  And what OS?

On my test system:

RAM: 4GB
IO: SSD (random_page_cost = 1.0)
OS: Ubuntu 16.04

Regards,
Sven

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [PERFORM] Speeding up JSON + TSQUERY + GIN
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [PERFORM] Speeding up JSON + TSQUERY + GIN