| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Karl Denninger *EXTERN*" <karl(at)denninger(dot)net>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Revisiting disk layout on ZFS systems |
| Date: | 2014-04-29 08:13:54 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17CF49B1@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Karl Denninger wrote:
> I've been doing a bit of benchmarking and real-world performance
> testing, and have found some curious results.
[...]
> The odd thing is that I am getting better performance with a 128k record
> size on this application than I get with an 8k one!
[...]
> What I am curious about, however, is the xlog -- that appears to suffer
> pretty badly from 128k record size, although it compresses even
> more-materially; 1.94x (!)
>
> The files in the xlog directory are large (16MB each) and thus "first
> blush" would be that having a larger record size for that storage area
> would help. It appears that instead it hurts.
As has been explained, the access patterns for WAL are quite different.
For your experiment, I'd keep them on different file systems so that
you can tune them independently.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl Denninger | 2014-04-29 12:12:37 | Re: Revisiting disk layout on ZFS systems |
| Previous Message | Tom Lane | 2014-04-28 23:06:06 | Re: Slow queries on 9.3.1 despite use of index |