Обсуждение: Uncommitted Data

Поиск
Список
Период
Сортировка

Uncommitted Data

От
Jonathan Tripathy
Дата:
Hi Everyone,

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?

Thanks

Re: Uncommitted Data

От
"Joshua D. Drake"
Дата:
On Wed, 2010-12-08 at 00:56 +0000, Jonathan Tripathy wrote:
> Hi Everyone,
>
> 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?

Yes, the transaction will rollback.

>
> Thanks
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

Re: Uncommitted Data

От
Simon Riggs
Дата:
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