From: Medi Montaseri <medi.montaseri@intransa.com>
To: Neil Conway <neilc@samurai.com>
Cc: Francisco Reyes <lists@natserv.com>
Cc: pgsql General List <pgsql-general@postgresql.org>
Subject: Re: Closing inactive connections OR user connections limits
Date: Wed, 20 Nov 2002 14:47:39 -0800
Message-ID: <3DDC110B.3030502@intransa.com> (raw)
References: <20021120135345.S30106-100000@zoraida.natserv.net>
<3DDBDBE5.6000505@intransa.com>
<87wun83p0k.fsf@mailbox.samurai.com>
Its my understanding that vacuum actually removes tuples that have been
updated or deleted.
Sort of like emptying your trash .... whence a tuple has been removed,
no rollback can set the
state back. If you have logically removed a tuple (not vacuumed yet),
then one can rollback,
but if you vacuum then you can not rollback.
Now suppose transaction A decides to delete some tuples, a vacuum job
comes along and
deletes things (in parallel), trans A decides to rollback....engines who
support parallel
vacuum-ing and transactions such as PG 7.2 better have a way of
protecting themselves
against this....
Correct me if ...
Neil Conway wrote:
>Medi Montaseri <medi.montaseri@intransa.com> writes:
>
>
>>I think from the data integrity point of view, vacuum is more
>>important than vacuum full.
>>
>>
>
>Why would VACUUM have any effect on data integrity, either positive or
>negative?
>
>Cheers,
>
>Neil
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: medi.montaseri@intransa.com, neilc@samurai.com, lists@natserv.com, pgsql-general@postgresql.org
Subject: Re: Closing inactive connections OR user connections limits
In-Reply-To: <3DDC110B.3030502@intransa.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox