Re: Performance of count(*)
This is a discussion on Re: Performance of count(*) within the Pgsql Performance forums, part of the PostgreSQL category; --> Am Donnerstag, 22. März 2007 15:33 schrieb Jonah H. Harris: > On 3/22/07, Merlin Moncure <mmoncure@gmail.com> wrote: > > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 10:24 AM
| ||||
| ||||
 Re: Performance of count(*) Am Donnerstag, 22. März 2007 15:33 schrieb Jonah H. Harris: > On 3/22/07, Merlin Moncure <mmoncure@gmail.com> wrote: > > As others suggest select count(*) from table is very special case > > which non-mvcc databases can optimize for. > > Well, other MVCC database still do it faster than we do. However, I > think we'll be able to use the dead space map for speeding this up a > bit wouldn't we? Which MVCC DB do you mean? Just curious... ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate      |
Linear Mode
