MVCC and index-only read

Поиск
Список
Период
Сортировка
От Scara Maccai
Тема MVCC and index-only read
Дата
Msg-id 898247.18852.qm@web28101.mail.ukl.yahoo.com
обсуждение исходный текст
Ответы Re: MVCC and index-only read  (Sam Mason <sam@samason.me.uk>)
Список pgsql-general
Hi,

if I got it right the reason some aggregates (such as COUNT) using only index columns are "slow" on postgresql is that
ituses MVCC, so it has to read the data as well as the index. It makes sense to me, but I don't understand is how other
databases(such as Oracle) do it. 
Can someone explain?

Thank you.



      Unisciti alla community di Io fotografo e video, il nuovo corso di fotografia di Gazzetta dello sport:
http://www.flickr.com/groups/iofotografoevideo

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how can I exclude stuff from template in my dumps?
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: FreeBSD 7 needing to allocate lots of shared memory