Re: two queryes in a single tablescan

From: "Steinar H(dot) 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: 2007-10-17 13:15:24
Message-ID: 20071017131524.GC3237@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql

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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stefano Dal Pra 2007-10-17 13:21:55 Re: two queryes in a single tablescan
Previous Message Heikki Linnakangas 2007-10-17 13:00:58 Re: two queryes in a single tablescan

Browse pgsql-sql by date

  From Date Subject
Next Message Stefano Dal Pra 2007-10-17 13:21:55 Re: two queryes in a single tablescan
Previous Message Heikki Linnakangas 2007-10-17 13:00:58 Re: two queryes in a single tablescan