Re: two queryes in a single tablescan - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: two queryes in a single tablescan
Date
Msg-id 471610A6.7070505@enterprisedb.com
Whole thread Raw
In response to Re: two queryes in a single tablescan  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Stefano Dal Pra"
Date:
Subject: Re: two queryes in a single tablescan
Next
From: Alvaro Herrera
Date:
Subject: Re: Vacuum goes worse