| 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: | 2007-10-17 13:39:50 |
| Message-ID: | 471610A6.7070505@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-10-17 13:43:28 | Re: Vacuum goes worse |
| Previous Message | Stefano Dal Pra | 2007-10-17 13:21:55 | Re: two queryes in a single tablescan |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boergesson, Cheryl | 2007-10-17 18:49:37 | |
| Previous Message | Stefano Dal Pra | 2007-10-17 13:21:55 | Re: two queryes in a single tablescan |