Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 09 May 2006 15:13:01 -0400
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
- Follow-Ups:
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- From: Jim C. Nasby
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- References:
- performance question (something to do w/ parameterized stmts?, wrong index types?)
- From: Jeffrey Tenny
- Re: performance question (something to do w/
- From: Mark Lewis
- Re: performance question (something to do w/
- From: Jim C. Nasby
- Re: performance question (something to do w/
- From: Tom Lane
- Big IN() clauses etc : feature proposal
- From: PFC
- Re: Big IN() clauses etc : feature proposal
- From: Christian Kratzer
- Re: Big IN() clauses etc : feature proposal
- From: PFC
- Re: Big IN() clauses etc : feature proposal
- From: Christian Kratzer
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- From: PFC
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- From: Martijn van Oosterhout
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- From: PFC
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- From: Mitchell Skinner
- Re: [HACKERS] Big IN() clauses etc : feature proposal
- From: PFC
- performance question (something to do w/ parameterized stmts?, wrong index types?)
- Prev by Date: Re: [GENERAL] Arguments Pro/Contra Software Raid
- Next by Date: Slow C Function
- Previous by thread: Re: [HACKERS] Big IN() clauses etc : feature proposal
- Next by thread: Re: [HACKERS] Big IN() clauses etc : feature proposal
- Indexes: