Re: MongoDB 3.2 beating Postgres 9.5.1? - Mailing list pgsql-general

From Michael Paquier
Subject Re: MongoDB 3.2 beating Postgres 9.5.1?
Date
Msg-id CAB7nPqR+S16xSnmRohHja=MDJ6f=-1FFjD8ubwb0GvC2iDoRWw@mail.gmail.com
Whole thread Raw
In response to Re: MongoDB 3.2 beating Postgres 9.5.1?  (Dmitry Dolgov <9erthalion6@gmail.com>)
List pgsql-general
On Mon, Mar 14, 2016 at 8:31 AM, Dmitry Dolgov wrote:
> As far as I know there isn't much to do about caching. I don't know if it's
> appropriate, but you can manually warm-up the cache (something like `cat
> /var/lib/postgresql/9.5/main/base/*/* > /dev/null`).

pg_prewarm may help as well. This has the advantage to not rely on
oid2name or similar for the relation selectivity.
--
Michael


pgsql-general by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: MongoDB 3.2 beating Postgres 9.5.1?
Next
From: Francisco Olarte
Date:
Subject: Re: Suppress decimal point like digits in to_char?