Re: slow commits with heavy temp table usage in 8.4.0 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: slow commits with heavy temp table usage in 8.4.0
Date
Msg-id 2814.1251055490@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
List pgsql-hackers
"Todd A. Cook" <tcook@blackducksoftware.com> writes:
> Tom Lane wrote:
>>> If you roll back a truncate, do you get the expected state?

> I did a number of variations on the test below, with and without "on drop commit",
> and similar tests where the "create table" is done before the "begin".  After the
> checkpoint, the number of files in the database directory always returned to the
> value before the "begin" (210 in this case).  Everything behaved as expected.

Thanks for doing the testing.  I've applied this patch to CVS HEAD.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Grzegorz Jaskiewicz
Date:
Subject: Re: clang's static checker report.
Next
From: Tom Lane
Date:
Subject: Re: clang's static checker report.