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