From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
---|---|
To: | andrew(at)supernews(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [ADMIN] Vacuum error on database postgres |
Date: | 2006-09-15 12:44:28 |
Message-ID: | 450AA02C.60000@logix-tt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2006-09-15 12:45:07 | Re: [ADMIN] Vacuum error on database postgres |
Previous Message | Andrew - Supernews | 2006-09-15 12:39:54 | Re: [ADMIN] Vacuum error on database postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2006-09-15 12:45:07 | Re: [ADMIN] Vacuum error on database postgres |
Previous Message | Andrew - Supernews | 2006-09-15 12:39:54 | Re: [ADMIN] Vacuum error on database postgres |