Re: atrocious update performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: atrocious update performance
Дата
Msg-id 27875.1079556722@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: atrocious update performance  ("Rosser Schwarz" <rschwarz@totalcardinc.com>)
Список pgsql-performance
"Rosser Schwarz" <rschwarz@totalcardinc.com> writes:
>> Regardless, something thinks it's still there.  Is there any way that
>> it is, and that I've somehow been running 7.3.2 all along?  `which
>> psql`, &c show the bindir from my configure, but I'm not sure that's
>> sufficient.

"select version()" is the definitive test for backend version.

> The weird thing is that I know I never built 7.3.anything with 32K
> BLCKSZ, never built 7.3.anything at all.  If 7.3 were installed, would
> it have any problem reading a 7.4 cluster?

7.3 would refuse to start on a 7.4 cluster, and vice versa.

            regards, tom lane

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

Предыдущее
От: "Rosser Schwarz"
Дата:
Сообщение: Re: atrocious update performance
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: rapid degradation after postmaster restart