Re: PostgreSQL on ZFS: performance tuning - Mailing list pgsql-performance

From trafdev
Subject Re: PostgreSQL on ZFS: performance tuning
Date
Msg-id 70bfa668-8904-8668-d0a6-6a6e27d38245@mail.ru
Whole thread Raw
In response to Re: PostgreSQL on ZFS: performance tuning  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List 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...


pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: PostgreSQL on ZFS: performance tuning
Next
From: Andreas Joseph Krogh
Date:
Subject: Very poor performance with Nested Loop Anti Join