Re: two queryes in a single tablescan

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: two queryes in a single tablescan
Дата
Msg-id 471610A6.7070505@enterprisedb.com
обсуждение исходный текст
Ответ на Re: two queryes in a single tablescan  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Stefano Dal Pra"
Дата:
Сообщение: Re: two queryes in a single tablescan
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Vacuum goes worse