Robert Haas wrote:
> On Fri, Mar 11, 2011 at 8:07 PM, Bruce Momjian wrote:
> > Currently, if you create a temporary table with the ON COMMIT action of
> > DELETE ROWS, the table will truncated for every commit, whether there is
> > any data in the table or not.
> >
> > I measured the overhead usin
On Mon, Mar 14, 2011 at 8:52 AM, Robert Haas wrote:
> On Fri, Mar 11, 2011 at 8:07 PM, Bruce Momjian wrote:
>> Currently, if you create a temporary table with the ON COMMIT action of
>> DELETE ROWS, the table will truncated for every commit, whether there is
>> any data in the table or not.
>>
>>
On Fri, Mar 11, 2011 at 8:07 PM, Bruce Momjian wrote:
> Currently, if you create a temporary table with the ON COMMIT action of
> DELETE ROWS, the table will truncated for every commit, whether there is
> any data in the table or not.
>
> I measured the overhead using this test:
>
> $ (echo
Currently, if you create a temporary table with the ON COMMIT action of
DELETE ROWS, the table will truncated for every commit, whether there is
any data in the table or not.
I measured the overhead using this test:
$ (echo 'CREATE TEMPORARY TABLE TEST2 (x int);'; jot -b 'SELECT 1;'
