Re: [HACKERS] Big IN() clauses etc : feature proposal - Mailing list pgsql-performance

From Csaba Nagy
Subject Re: [HACKERS] Big IN() clauses etc : feature proposal
Date
Msg-id 1147171926.14093.242.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: [HACKERS] Big IN() clauses etc : feature proposal  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-performance
[snip]
> It would be interesting to know what the bottleneck is for temp tables
> for you. They do not go via the buffer-cache, they are stored in
[snip]

Is it possible that the temp table creation is the bottleneck ? Would
that write into system catalogs ? If yes, maybe the system catalogs are
not adequately vacuumed/analyzed.

Just a thought.

Cheers,
Csaba.



pgsql-performance by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Next
From: PFC
Date:
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal