Hi, Andrew, Andrew - Supernews wrote:
>> Is there any reason to allow ANALYZE run insinde a transaction at all? > > Absolutely. In a large transaction that radically changes the content of > the database, it is often necessary to analyze in order to avoid getting > extremely bad query plans for later commands in the transaction. OK, I see. But this leads to the danger that, should the transaction abort afterwards, we're left with borked stats, or are those rolled back accordingly? Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature