Re: atrocious update performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rosser Schwarz" <rschwarz(at)totalcardinc(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: atrocious update performance
Date: 2004-03-17 20:52:02
Message-ID: 27875.1079556722@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Rosser Schwarz" <rschwarz(at)totalcardinc(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2004-03-17 20:57:09 Re: rapid degradation after postmaster restart
Previous Message Rosser Schwarz 2004-03-17 20:43:36 Re: atrocious update performance