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

From Steinar H. Gunderson
Subject Re: two queryes in a single tablescan
Date
Msg-id 20071017131524.GC3237@uio.no
Whole thread Raw
In response to two queryes in a single tablescan  ("Stefano Dal Pra" <s.dalpra@gmail.com>)
Responses Re: two queryes in a single tablescan  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-performance
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/

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: two queryes in a single tablescan
Next
From: "Stefano Dal Pra"
Date:
Subject: Re: two queryes in a single tablescan