From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Greg Stark <stark(at)mit(dot)edu> |
Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 9.4 regression |
Date: | 2013-08-08 00:40:24 |
Message-ID: | CAA-aLv4MiCiNc1m9JcPY80pZmez-jZ5BkrJshC+vAfhaRS4Nug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 8 August 2013 00:04, Thom Brown <thom(at)linux(dot)com> wrote:
> On 7 August 2013 23:40, Greg Stark <stark(at)mit(dot)edu> wrote:
>> Did you report information about the system affected? What filesystem is it
>> on? If it's ext4 does it have extents enabled?
>
> Yes, ext4. It's using whatever the default options are, but running
> lsattr on my data dir shows that extents are being used.
I've just created an ext2 partition (so no extents), and did some
quick benchmarks of those 2 commits. This is on the original system
(not my laptop), with the same config settings as before. All tests
initialised with -s 20 and tested with -j 80 -c 80.
30 seconds:
8800d8: 1327.983018 / 1317.848514
269e78: 1388.009819 / 1285.929100
5 minutes:
8800d8: 1744.446592 / 1729.602706
269e78: 1677.561277 / 1677.967873
10 minutes:
8800d8: 1753.147609 / 1806.600335
269e78: 1815.862842 / 1804.906769
So this appears to be okay.
--
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2013-08-08 00:58:06 | Re: 9.4 regression |
Previous Message | Ryan Kelly | 2013-08-08 00:12:57 | Re: Has anybody been able to install Pg 9.3 beta .debs on Ubuntu 12.04 |