Re: PostgreSQL on ZFS: performance tuning

From: trafdev <trafdev(at)mail(dot)ru>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL on ZFS: performance tuning
Date: 2016-07-29 06:47:22
Message-ID: 70bfa668-8904-8668-d0a6-6a6e27d38245@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > - from what I can see, Postgres uses memory too carefully. I would like
> > somehow to force it to keep accessed data in memory as long as possible.
> > Instead I often see that even frequently accessed data is pushed out of
> > memory cache for no apparent reasons.
> >
>
> This is probably a consequence of the primarycache misconfiguration.

Thanks! And I'm using "primarycache=all" in my deployment...

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Joseph Krogh 2016-08-01 13:33:04 Very poor performance with Nested Loop Anti Join
Previous Message Tomas Vondra 2016-07-29 06:30:49 Re: PostgreSQL on ZFS: performance tuning