On Wed, 09 Jan 2008 20:29:39 +0100 Zoltan Boszormenyi <zb@xxxxxxxxxxx> wrote: > The decision to use MVCC in PostgreSQL makes the point moot. ... thanks. > In PostgreSQL, COUNT(*) responds closely at the same speed > regardless of other transactions. Which way do you prefer? Considering the relative value of count my interest was for something that is even less precise than the "usual" count but performs better. I'm not proposing to turn Postgres into MySQL. -- Ivan Sergio Borgonovo http://www.webthatworks.it ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match