pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAdd slowdown after conversion to UTF8
3+ messages / 3 participants
[nested] [flat]
* Add slowdown after conversion to UTF8
@ 2010-06-17 22:28 Brant Fitzsimmons <brant.fitzsimmons@gmail.com>
2010-06-17 23:17 ` Re: Add slowdown after conversion to UTF8 Tom Lane <tgl@sss.pgh.pa.us>
2010-06-18 04:09 ` Re: Add slowdown after conversion to UTF8 Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 3+ messages in thread
From: Brant Fitzsimmons @ 2010-06-17 22:28 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Add slowdown after conversion to UTF8
2010-06-17 22:28 Add slowdown after conversion to UTF8 Brant Fitzsimmons <brant.fitzsimmons@gmail.com>
@ 2010-06-17 23:17 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2010-06-17 23:17 UTC (permalink / raw)
To: Brant Fitzsimmons <brant.fitzsimmons@gmail.com>; +Cc: pgsql-performance
Brant Fitzsimmons <brant.fitzsimmons@gmail.com> writes:
> 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?
Well, with no specifics on performance of *what*, it's hard to say.
There are certain operations that could be quite a bit slower, yes.
I haven't heard of too many people noticing a problem though.
It's probably worth noting that locale could be at least as much of a
factor as encoding ... but perhaps I'm jumping to conclusions about
what your slow operations are.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Add slowdown after conversion to UTF8
2010-06-17 22:28 Add slowdown after conversion to UTF8 Brant Fitzsimmons <brant.fitzsimmons@gmail.com>
@ 2010-06-18 04:09 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2010-06-18 04:09 UTC (permalink / raw)
To: Brant Fitzsimmons <brant.fitzsimmons@gmail.com>; +Cc: pgsql-performance
On tor, 2010-06-17 at 18:28 -0400, Brant Fitzsimmons wrote:
> Performance has dropped through the floor after converting my db from
> ASCI to UTF8.
Converting from ASCII to UTF8 is a noop.
If you did some configuration changes, you need to tell us which.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-06-18 04:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-17 22:28 Add slowdown after conversion to UTF8 Brant Fitzsimmons <brant.fitzsimmons@gmail.com>
2010-06-17 23:17 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-06-18 04:09 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox