Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: two queryes in a single tablescan
- From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- To: Stefano Dal Pra <s(dot)dalpra(at)gmail(dot)com>, 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 14:39:50 +0100
Steinar H. Gunderson wrote: > 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. You'd have to run the seq scans at the same time, from two different backends, so it's not going to help here. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
- References:
- two queryes in a single tablescan
- From: Stefano Dal Pra
- Re: two queryes in a single tablescan
- From: Steinar H. Gunderson
- two queryes in a single tablescan
- Prev by Date: Re: two queryes in a single tablescan
- Next by Date: Re: Vacuum goes worse
- Previous by thread: Re: two queryes in a single tablescan
- Next by thread: Re: two queryes in a single tablescan
- Indexes: