Re: CentOS - PostgreSQL 9.2.13 -> 9.4

Hi Alvaro,

On 18/08/15 17:41, Alvaro Herrera wrote:
> Alvaro Herrera wrote:
>
>> One thing to look at is the rate of WAL generation for a set number of
>> transactions.  Maybe the later releases are generating more WAL due to
>> multixacts, for instance (prior to 9.3 these weren't wal-logged.)
>
> Also try 9.5alpha2, wherein bug #8470 is fixed, which is a big
> performance regression in 9.3 and 9.4.

Unfortunately I can't get into alpha releases, nor beta. This server
will go into production in around 7 days time.

I had a month to get this dealt with originally, two weeks were spent
tweaking 9.2.13 (provided from CentOS base) with the intention of
staying with that version.

Then I wanted to see better TPS on high client numbers and moved to 9.4,
even this took a little persuasion with my colleague... 9.5 is
definitely a no.

Thanks

Michael


>