Re: [ADMIN] Vacuum error on database postgres - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: [ADMIN] Vacuum error on database postgres
Date
Msg-id slrnegl7oq.2ea3.andrew+nonews@atlantis.supernews.net
Whole thread Raw
In response to Re: [ADMIN] Vacuum error on database postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [ADMIN] Vacuum error on database postgres
List pgsql-hackers
On 2006-09-15, Markus Schaber <schabi@logix-tt.com> 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.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Fixed length data types issue
Next
From: Markus Schaber
Date:
Subject: Re: [ADMIN] Vacuum error on database postgres