Re: [ADMIN] Vacuum error on database postgres

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [ADMIN] Vacuum error on database postgres
Date: 2006-09-15 12:39:54
Message-ID: slrnegl7oq.2ea3.andrew+nonews@atlantis.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On 2006-09-15, Markus Schaber <schabi(at)logix-tt(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Schaber 2006-09-15 12:44:28 Re: [ADMIN] Vacuum error on database postgres
Previous Message Nick Howden 2006-09-15 12:11:45 Auto Vacuum not starting unless postgres is restarted

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Schaber 2006-09-15 12:44:28 Re: [ADMIN] Vacuum error on database postgres
Previous Message Gregory Stark 2006-09-15 12:39:36 Re: Fixed length data types issue