Re: temp table "on commit delete rows": transaction overhead - Mailing list pgsql-performance

From Tom Lane
Subject Re: temp table "on commit delete rows": transaction overhead
Date
Msg-id 26236.1269971456@sss.pgh.pa.us
Whole thread Raw
In response to temp table "on commit delete rows": transaction overhead  (Artiom Makarov <artiom.makarov@gmail.com>)
Responses Re: temp table "on commit delete rows": transaction overhead  (Bruce Momjian <bruce@momjian.us>)
Re: temp table "on commit delete rows": transaction overhead  (Artiom Makarov <artiom.makarov@gmail.com>)
List pgsql-performance
Artiom Makarov <artiom.makarov@gmail.com> writes:
> When temp tables with "on commit delete rows" exists, I can see a
> strange delay at any �begin� and �commit�.

A delay at commit is hardly surprising, because each such temp table
requires filesystem operations at commit (basically an "ftruncate").
I don't recall any operations at transaction start for such tables,
but there may be some.

            regards, tom lane

pgsql-performance by date:

Previous
From: Faheem Mitha
Date:
Subject: Re: experiments in query optimization
Next
From: Robert Haas
Date:
Subject: Re: experiments in query optimization