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

From Artiom Makarov
Subject Re: temp table "on commit delete rows": transaction overhead
Date
Msg-id q2td448ea361004050056ifed022e3t3ca6e2cca7eaac61@mail.gmail.com
Whole thread Raw
In response to Re: temp table "on commit delete rows": transaction overhead  (Bruce Momjian <bruce@momjian.us>)
List pgsql-performance
2010/4/1 Bruce Momjian <bruce@momjian.us>:

> I think one of the problems is that we do the truncate even if the table
> has not be touched by the query, which is poor behavior.

Thank you for the support.
Will be this problem registered?

PS
I see a workaround: switch off "on commit delete rows" on temp tables
and use txid_current() to control transaction visibility.

pgsql-performance by date:

Previous
From: Joel Jacobson
Date:
Subject: LIMIT causes planner to do Index Scan using a less optimal index
Next
From: Brian Cox
Date:
Subject: Re: query slow; strace output worrisome