Info about concurrent sequential scans
От
Daniele Varrazzo
Тема
Info about concurrent sequential scans
Дата
Msg-id
15bf30d21002221122x6f0e5a8md84a01ccac0f9109@mail.gmail.com
Список
Дерево обсуждения
Info about concurrent sequential scans Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: Info about concurrent sequential scans Bruce Momjian <bruce@momjian.us>
Re: Info about concurrent sequential scans Andreas Kretschmer <akretschmer@spamfence.net>
Re: Info about concurrent sequential scans Daniele Varrazzo <daniele.varrazzo@gmail.com>
Hello, at Prato PgDay in 2007 I remember hearing in a speech about a (then yet to come) "seqscan piggyback" feature, allowing concurrent sequential scans to use the same disk reads. I've now googled for info about this feature, but I found nothing conclusive (e.g. [1], [2] - which I don't know where is linked). So I'd like to know: is this feature currently implemented (I'm specifically interested in PG 8.3)? Is there any prerequisite needed to benefit from it (config setting, query characteristic, etc.)? Is there any feedback showing the feature kicking in (e.g. an explain analyze output, log, etc.)? Thank you very much. -- Daniele [1] http://wordpress.metro.cx/2008/02/24/postgresql-83/ [2] http://www.postgresql.org/about/featuredetail/feature.26
В списке pgsql-general по дате отправления