Re: [GENERAL] PostgreSQL Gotchas --- count()

2005-10-07 Thread Gregory S. Williamson
>> Gregory S. Williamson wrote: >>> [ re COUNT(*) ] >>> On Informix however it is blindingly fast, and can also be instantly >>> conjured with the dbaccess tool (Info/Table/Status). They might be >>> stashing this count somewhere, but it is not available when the table >>> is locked, as during a

Re: [GENERAL] PostgreSQL Gotchas --- count()

2005-10-06 Thread Tom Lane
Bruce Momjian writes: > Gregory S. Williamson wrote: >> [ re COUNT(*) ] >> On Informix however it is blindingly fast, and can also be instantly >> conjured with the dbaccess tool (Info/Table/Status). They might be >> stashing this count somewhere, but it is not available when the table >> is locke

Re: [GENERAL] PostgreSQL Gotchas --- count()

2005-10-06 Thread Bruce Momjian
Gregory S. Williamson wrote: > On Informix however it is blindingly fast, and can also be instantly > conjured with the dbaccess tool (Info/Table/Status). They might be > stashing this count somewhere, but it is not available when the table > is locked, as during a load. However they do it, perform

Re: [GENERAL] PostgreSQL Gotchas --- count()

2005-10-06 Thread Gregory S. Williamson
On Informix however it is blindingly fast, and can also be instantly conjured with the dbaccess tool (Info/Table/Status). They might be stashing this count somewhere, but it is not available when the table is locked, as during a load. However they do it, performance does not seem to suffer, and