Re: What's the state of postgresql on ext4 now? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: What's the state of postgresql on ext4 now?
Date
Msg-id CAOR=d=1gFe+Rr=JqQgG7gncRWQb8d4S6C6sTa6zUkHZzZNpEAg@mail.gmail.com
Whole thread Raw
In response to Re: What's the state of postgresql on ext4 now?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Tue, Nov 15, 2011 at 1:48 PM, Josh Berkus <josh@agliodbs.com> wrote:
> On 11/14/11 2:00 AM, Alexandru wrote:
>> I know there were a lot of performance issues with ext4, but i don't know the state of it now.
>> I have a private openstreetmap server installed on a ubuntu 11.10 64bit pc with both partitions (/ and /home)
formatedwith ext4. My problem is that the server works very slow. 
>
> Why would you assume this has anything to do with Ext4?  Other
> configuration issues seem more likely.

I think that about a year or so ago the linux kernel finally started
making ext4 obey barriers and / or fsync properly, and the performance
fell back into line with other file systems that also obeyed fsync.
Combined with a rather histrionic report from phoronix many people
were led to believe that ext4 suddenly became very slow when it fact
it just stopped being artificially fast.

Just a guess tho.

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: unlogged tables
Next
From: Tomas Vondra
Date:
Subject: Re: Slow queries / commits, mis-configuration or hardware issues?