Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-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

pgsql-performance by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group