Re: Upgrade to 8.3.0? - Mailing list pgsql-general

From Shane Wright
Subject Re: Upgrade to 8.3.0?
Date
Msg-id 952015000A644E44B2FB8759E151093B02F307@exchange11.ad.edigitalresearch.com
Whole thread Raw
In response to Upgrade to 8.3.0?  ("Shane Wright" <shane.wright@edigitalresearch.com>)
Responses Re: Upgrade to 8.3.0?
Re: Upgrade to 8.3.0?
List pgsql-general
Tom
 
Many thanks :)
 
I've tried to find this out for myself but have failed :(
 
I'm assuming that the default RPMs for RHEL 4 (on ftp.postgresql.org) are not built with --enable-cassert - and that I can veryify this by using the same reproduction case you demonstrated in the bug history?
 
(I should just get the memory allocation error on attempting to vacuum full - instead of an assertion failing and bringing down the whole PostgreSQL server (panic?))
 
Please could you confirm my assertion (sic) is correct?
 
(I get this behaviour on my test server and all appears to be ok)
 
Kind regards
 
Shane
 


From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Fri 29/02/2008 19:46
To: Shane Wright
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Upgrade to 8.3.0?

Shane Wright writes:
> -          Is the HOT/VACUUMFULL bug above dangerous or is its biggest
> side-effect an error until a non-full vacuum is run?

As long as you don't build with --enable-cassert, that bug isn't real
nasty.  Especially if you don't do VACUUM FULL routinely ;-)

                        regards, tom lane

pgsql-general by date:

Previous
From: abracadabuda
Date:
Subject: pgsql structure export to XML
Next
From: Thomas Kellerer
Date:
Subject: Re: pgsql structure export to XML