Re: Bitmap scans vs. the statistics views

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Bitmap scans vs. the statistics views
Дата
Msg-id 20050422182345.GR58835@decibel.org
обсуждение исходный текст
Ответ на Bitmap scans vs. the statistics views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I would like to know if bitmap scans are being used on a table. I think
it's worth adding to the stats views, though I'm not sure on the best
way. For example, this means that a query on one table can now scan
multiple indexes, but it doesn't seem right to lump that in with
'traditional' index scans. An extreme view would be to add new bitmap
scan columns to pg_stat(io)_(tables|indexes), but that might be
overkill.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Woo hoo ... a whole new set of compiler headaches!! :)
Следующее
От: "Dave Held"
Дата:
Сообщение: Re: Woo hoo ... a whole new set of compiler headaches!!