From: | Howard Cole <howardnews(at)selestial(dot)com> |
---|---|
To: | Leif Biberg Kristensen <leif(at)solumslekt(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Configuration Optimisation |
Date: | 2010-01-14 17:03:35 |
Message-ID: | 4B4F4E67.8070700@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2010-01-14 18:17:16 | Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour |
Previous Message | Leif Biberg Kristensen | 2010-01-14 16:04:43 | Re: Configuration Optimisation |