Re: [PERFORM] Speeding up JSON + TSQUERY + GIN
От
Jeff Janes
Тема
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN
Дата
Msg-id
CAMkU=1xyf5ypGew=cgFuczQHqtc59J1CTf2EugF0hwSWu65ZCA@mail.gmail.com
Ответ на
[PERFORM] Speeding up JSON + TSQUERY + GIN (Sven R. Kunze)
Список
Дерево обсуждения
[PERFORM] Speeding up JSON + TSQUERY + GIN "Sven R. Kunze" <srkunze@mail.de>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Oleg Bartunov <obartunov@gmail.com>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN "Sven R. Kunze" <srkunze@mail.de>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes <jeff.janes@gmail.com>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN "Sven R. Kunze" <srkunze@mail.de>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes <jeff.janes@gmail.com>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN "Sven R. Kunze" <srkunze@mail.de>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes <jeff.janes@gmail.com>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN "Sven R. Kunze" <srkunze@mail.de>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes <jeff.janes@gmail.com>
Re: [PERFORM] Speeding up JSON + TSQUERY + GIN "Sven R. Kunze" <srkunze@mail.de>
On Sun, Feb 26, 2017 at 5:28 AM, Sven R. Kunze <srkunze@mail.de> wrote:
Using "select pg_prewarm('docs');" and on any of the indexes doesn't help either.
After a "systemctl stop postgresql.service && sync && echo 3 > /proc/sys/vm/drop_caches && systemctl start postgresql.service" the age=20, 30 or name=john queries are slow again.
Is there a way to speed up or to warm up things permanently?
If by 'permanently', you mean even when you intentionally break things, then no. You will always be able to intentionally break things. There is on-going discussion of an auto-prewarm feature. But that doesn't yet exist; and once it does, a super user will always be able to break it.
Presumably you have a use-case in mind other than intentional sabotage of your caches by root. But, what is it? If you reboot the server frequently, maybe you can just throw 'select pg_prewarm...' into an init script?
Cheers,
Jeff
В списке pgsql-performance по дате отправления
