strange performance regression between 7.4 and 8.1

Поиск
Список
Период
Сортировка
От Alex Deucher
Тема strange performance regression between 7.4 and 8.1
Дата
Msg-id a728f9f90703011244r577d56d7y422ab4bd71bb760e@mail.gmail.com
обсуждение исходный текст
Ответы Re: strange performance regression between 7.4 and 8.1  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: strange performance regression between 7.4 and 8.1  (Florian Weimer <fweimer@bfk.de>)
Re: strange performance regression between 7.4 and 8.1  (Anton Rommerskirchen <atr@atrsoft.de>)
Список pgsql-performance
Hello,

I have noticed a strange performance regression and I'm at a loss as
to what's happening.  We have a fairly large database (~16 GB).  The
original postgres 7.4 was running on a sun v880 with 4 CPUs and 8 GB
of ram running Solaris on local scsi discs.  The new server is a sun
Opteron box with 4 cores, 8 GB of ram running postgres 8.1.4 on Linux
(AMD64) on a 4 Gbps FC SAN volume.  When we created the new database
it was created from scratch rather than copying over the old one,
however the table structure is almost identical (UTF8 on the new one
vs. C on the old). The problem is queries are ~10x slower on the new
hardware.  I read several places that the SAN might be to blame, but
testing with bonnie and dd indicates that the SAN is actually almost
twice as fast as the scsi discs in the old sun server.  I've tried
adjusting just about every option in the postgres config file, but
performance remains the same.  Any ideas?

Thanks,

Alex

В списке pgsql-performance по дате отправления:

Предыдущее
От: Benjamin Minshall
Дата:
Сообщение: Re: stats collector process high CPU utilization
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1