Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: two queryes in a single tablescan
- From: "Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)com>
- To: Stefano Dal Pra <s(dot)dalpra(at)gmail(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
- Subject: Re: two queryes in a single tablescan
- Date: Wed, 17 Oct 2007 15:15:24 +0200
On Wed, Oct 17, 2007 at 02:30:52PM +0200, Stefano Dal Pra wrote: > The main goal would be to get multiple results while scanning the > table[s] once only > thus getting results in a faster way. In 8.3, Postgres will do this for you itself -- if you already have a sequential scan running against a given table, another one starting in parallel will simply piggyback it. /* Steinar */ -- Homepage: http://www.sesse.net/
- Follow-Ups:
- Re: two queryes in a single tablescan
- From: Heikki Linnakangas
- Re: two queryes in a single tablescan
- References:
- two queryes in a single tablescan
- From: Stefano Dal Pra
- two queryes in a single tablescan
- Prev by Date: Re: two queryes in a single tablescan
- Next by Date: Re: two queryes in a single tablescan
- Previous by thread: Re: two queryes in a single tablescan
- Next by thread: Re: two queryes in a single tablescan
- Indexes: