Re: Speeding up JSON + TSQUERY + GIN

On Sun, Feb 26, 2017 at 5:28 AM, Sven R. Kunze <srkunze(at)mail(dot)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