Re: two queryes in a single tablescan

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: two queryes in a single tablescan
Дата
Msg-id 20071017131524.GC3237@uio.no
обсуждение исходный текст
Ответ на two queryes in a single tablescan  ("Stefano Dal Pra" <s.dalpra@gmail.com>)
Ответы Re: two queryes in a single tablescan  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-performance
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/

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

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