Re: MongoDB 3.2 beating Postgres 9.5.1?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
Cc: Oleg Bartunov <obartunov(at)gmail(dot)com>, Paul Jones <pbj(at)cmicdo(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: MongoDB 3.2 beating Postgres 9.5.1?
Date: 2016-03-14 08:04:31
Message-ID: CAB7nPqR+S16xSnmRohHja=MDJ6f=-1FFjD8ubwb0GvC2iDoRWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-03-14 10:31:47 Re: Suppress decimal point like digits in to_char?
Previous Message Dmitry Dolgov 2016-03-14 07:31:36 Re: MongoDB 3.2 beating Postgres 9.5.1?