| From: | Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | "Aly S(dot)P Dharshi" <aly(dot)dharshi(at)telus(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Gotchas |
| Date: | 2005-10-06 22:47:36 |
| Message-ID: | 4345A988.8040508@visualdistortion.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Neil Conway wrote:
>
>"COUNT(*) very slow": this is a known issue -- see the -hackers archives
>for many prior discussions. MVCC makes this hard to solve effectively
>(whether applications should actually be using COUNT(*) on large tables
>with no WHERE clause is another matter...)
>
>-Neil
>
>
And it's not like a count(*) on an Oracle database of any decently-sized
dataset is blazing fast, or even in blazing's ballpark.
The only thing I could see actually being an issue is the random() one
and add missing from. The rest are trivial. The random() thing is
interesting, esoteric, and probably has never been a problem in a real
situation. (Or has exactly once, when he wrote that gotcha)
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CSN | 2005-10-06 23:00:27 | Re: PostgreSQL Gotchas |
| Previous Message | Mark Cave-Ayland | 2005-10-06 22:42:57 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |