Re: Configuration Optimisation - Mailing list pgsql-general

From Howard Cole
Subject Re: Configuration Optimisation
Date
Msg-id 4B4F4E67.8070700@selestial.com
Whole thread Raw
In response to Re: Configuration Optimisation  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-general
Leif Biberg Kristensen wrote:
> On Thursday 14. January 2010 16.55.07 Howard Cole wrote:
>
>> Leif Biberg Kristensen wrote:
>>
>>> On Thursday 14. January 2010 16.02.12 Andy Colson wrote:
>>>
>>> See my reply above. My 250 tps seems in line with the 700 tps on a modern
>>> system that the OP gets on his Windows setup. To me it seems like
>>>
> something is
>
>>> broken on his Ubuntu setup.
>>>
>>> regards,
>>>
>>>
>> I am hoping your assumptions are correct. I have reinstalled ubuntu from
>> scratch as I had been tinkering with the power management on the server.
>> Once the RAID has rebuilt, I shall try again.
>>
>
> What kind of file system are you running?
>
> regards,
>
The file system is ext4. If I turn fsync off I get a TPS of 1120 so I
think there is an issue with the speed of the array.

The dd test give a speed of 125MB/s which seems reasonable to me.

I can leave fsync off but I suspect that I am just ignoring the problem.

Howard.

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Configuration Optimisation
Next
From: Pavel Stehule
Date:
Subject: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour