Re: RAM-only temporary tables

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> Tom Lane wrote:
>> Heikki, would it be reasonable to fix things so that a nonexistent FSM
>> fork is semantically the same as an empty one, and not create FSM until
>> there's actually something to put in it?

> Possibly, but I'd like to understand what exactly the problem is. I 
> tried running this:

> CREATE TEMPORARY TABLE footemp (id int4);
> DROP TABLE footemp;

> with pgbench -f, but can't see any meaningful difference between 8.3 and 
> CVS HEAD. Both can do about 300 tpm, or 700-800 with fsync=off.

Try several thousand temp tables within one transaction.
        regards, tom lane