Home > mailing lists

Add slowdown after conversion to UTF8 - Mailing list pgsql-performance

From	Brant Fitzsimmons
Subject	Add slowdown after conversion to UTF8
Date	June 17, 2010 22:37:08
Msg-id	AANLkTimNA82M6JLXsp8oTiynIQSMH6fei7XSQkOJ-Y77@mail.gmail.com Whole thread Raw
Responses	Re: Add slowdown after conversion to UTF8 Re: Add slowdown after conversion to UTF8
List	pgsql-performance

Hello there,

I've searched the web and can find very little on this issue, so I was hoping those on this list would be able to shed some light on it.

Performance has dropped through the floor after converting my db from ASCI to UTF8. Is this normal behavior on 8.4.x?

I'm mystified as to the problem. Thanks for any input you can provide.

--
Brant Fitzsimmons
"Everything should be made as simple as possible, but not simpler." -- Albert Einstein

From: Greg Smith
Date: 17 June 2010, 21:42:07
Subject: Re: requested shared memory size overflows size_t

From: Josh Berkus
Date: 17 June 2010, 23:01:42
Subject: Re: PostgreSQL as a local in-memory cache