| From: | trafdev <trafdev(at)mail(dot)ru> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL on ZFS: performance tuning |
| Date: | 2016-09-28 18:42:13 |
| Message-ID: | d85e46d8-1a9c-92a1-f382-4a18a9612ad3@mail.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)denninger(dot)net <mailto:karl(at)denninger(dot)net>
> /The Market Ticker/
> /[S/MIME encrypted email preferred]/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl Denninger | 2016-09-28 19:06:35 | Re: PostgreSQL on ZFS: performance tuning |
| Previous Message | Jake Nielsen | 2016-09-28 18:11:13 | Re: Unexpected expensive index scan |