Read uncommitted ever possible?
От | hans wulf |
---|---|
Тема | Read uncommitted ever possible? |
Дата | |
Msg-id | 20110310123103.31170@gmx.net обсуждение исходный текст |
Ответы |
Re: Read uncommitted ever possible?
Re: Read uncommitted ever possible? Re: Read uncommitted ever possible? |
Список | pgsql-hackers |
Hi, if you want to do dirty counts or sums or any aggreate stuff, you will always have to visit the table. For many applicationsnobody cares about 0,01% inaccuracy. If you could keep the data that has to be aggregated in the index you could approximate values really fast. But because "Read uncommitted" is not implemented you will always have to visit the table. This is one reason why peoplehave to still buy oracle. I don't know the postgres code, but I don't thing it is a big deal, not to care about consistancy. The code for executingsuch a query should be quite basic, because no MVCC-Stuff has to be done. Will this feature come any time soon? Even if "Read uncommitted" is a "could read all sorts of old and dirty stuff" it isstill better than nothing. -- NEU: FreePhone - kostenlos mobil telefonieren und surfen! Jetzt informieren: http://www.gmx.net/de/go/freephone
В списке pgsql-hackers по дате отправления: