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

From trafdev
Subject Re: PostgreSQL on ZFS: performance tuning
Date
Msg-id d85e46d8-1a9c-92a1-f382-4a18a9612ad3@mail.ru
Whole thread Raw
In response to Re: PostgreSQL on ZFS: performance tuning  (Karl Denninger <karl@denninger.net>)
Responses Re: PostgreSQL on ZFS: performance tuning  (Karl Denninger <karl@denninger.net>)
List pgsql-performance
Thanks Jov and Karl!

What do you think about:

primarycache=all

for SELECT queries over same data sets?

Yes.

Non-default stuff...

dbms/ticker-9.5  compressratio         1.88x                  -
dbms/ticker-9.5  mounted               yes                    -
dbms/ticker-9.5  quota                 none                   default
dbms/ticker-9.5  reservation           none                   default
dbms/ticker-9.5  recordsize            128K                   default
dbms/ticker-9.5  mountpoint            /dbms/ticker-9.5       local
dbms/ticker-9.5  sharenfs              off                    default
dbms/ticker-9.5  checksum              on                     default
dbms/ticker-9.5  compression           lz4                    inherited from dbms
dbms/ticker-9.5  atime                 off                    inherited from dbms
dbms/ticker-9.5  logbias               throughput             inherited from dbms


--
Karl Denninger
karl@denninger.net
The Market Ticker
[S/MIME encrypted email preferred]

pgsql-performance by date:

Previous
From: Jake Nielsen
Date:
Subject: Re: Unexpected expensive index scan
Next
From: Karl Denninger
Date:
Subject: Re: PostgreSQL on ZFS: performance tuning