Re: atrocious update performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: atrocious update performance
Date
Msg-id 27875.1079556722@sss.pgh.pa.us
Whole thread Raw
In response to Re: atrocious update performance  ("Rosser Schwarz" <rschwarz@totalcardinc.com>)
List 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 by date:

Previous
From: "Rosser Schwarz"
Date:
Subject: Re: atrocious update performance
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: rapid degradation after postmaster restart