Re: Uncommitted Data - Mailing list pgsql-general

From Simon Riggs
Subject Re: Uncommitted Data
Date
Msg-id 1291841660.2872.1320.camel@ebony
Whole thread Raw
In response to Uncommitted Data  (Jonathan Tripathy <jonnyt@abpni.co.uk>)
List pgsql-general
On Wed, 2010-12-08 at 00:56 +0000, Jonathan Tripathy wrote:

> What does PG do with data that has been inserted into a table, but was
> never committed? Does the data get discarded once the connection dies?

The data is there, but is not visible. You can run an explicit VACUUM to
remove the "dead rows", or you can wait for it to be garbage collected
automatically at some point in the future, depending upon your workload.

--
 Simon Riggs           http://www.2ndQuadrant.com/books/
 PostgreSQL Development, 24x7 Support, Training and Services



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations
Next
From: Simon Riggs
Date:
Subject: Re: pg_standby logging issues