| 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: | Whole Thread | Raw Message | 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/
| 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 |
| 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 |