Re: [HACKERS] Big IN() clauses etc : feature proposal

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: PFC <lists(at)peufeu(dot)com>
Cc: "Mitchell Skinner" <mitch(at)arctur(dot)us>, pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Date: 2006-05-09 19:13:01
Message-ID: 16680.1147201981@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

PFC <lists(at)peufeu(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-05-09 19:43:30 Re: Inheritance, Primary Keys and Foreign Keys
Previous Message Tom Lane 2006-05-09 19:04:57 Re: Number of dimensions of an array parameter

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Palmblad 2006-05-09 21:57:09 Slow C Function
Previous Message Scott Marlowe 2006-05-09 19:04:08 Re: [PERFORM] Arguments Pro/Contra Software Raid