[Gllug] Introductions to Databases

[Peter Childs]

2009/7/17 Peter Corlett <abuse at cabal.org.uk>:
> On Fri, Jul 17, 2009 at 02:25:01PM +0100, Sean Burlington wrote:
> [...]
>> This is worth reading too
>> http://sql-info.de/postgresql/postgres-gotchas.html
>
> Mind you, PostgreSQL fixed most of those *years* ago. It is a rather old
> list.
>
> The only real showstopper left out of that lot is that COUNT(*) is still
> expensive.

The problem with anything with a fast count(*) is that it does not
necessarily count but keep a running counter, and running counters
have this habit of going wrong. (Used them loads of times and they
break fairly regularly...... So a fast count(*) that does not actually
count may not be telling the truth.....

Peter.
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug