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

From Tom Lane
Subject Re: [HACKERS] Big IN() clauses etc : feature proposal
Date
Msg-id 16680.1147201981@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Big IN() clauses etc : feature proposal  (PFC <lists@peufeu.com>)
Responses Re: [HACKERS] Big IN() clauses etc : feature proposal
List pgsql-performance
PFC <lists@peufeu.com> writes:
>     Fun thing is, the rowcount from a temp table (which is the problem here)
> should be available without ANALYZE ; as the temp table is not concurrent,
> it would be simple to inc/decrement a counter on INSERT/DELETE...

No, because MVCC rules still apply.

            regards, tom lane

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Arguments Pro/Contra Software Raid
Next
From: "Adam Palmblad"
Date:
Subject: Slow C Function