Re: COUNT and Performance ...

Neil Conway wrote:

>On Sun, 2003-02-02 at 03:55, Hans-Jürgen Schönig wrote:
>
>
>>If people want to count ALL rows of a table. The contrib stuff is pretty
>>useful. It seems to be transaction safe.
>>
>>
>
>Interesting -- I didn't know about the contrib stuff. I'll update the
>docs patch.
>
>Cheers,
>
>Neil
>
>

Personall I think a system table containing information about all tables
in the database would be best. The contrib stuff provides a lot of
useful information which would be perfect for a system view (dead
tuples, number of records, ...). I guess many people would consider that
to be useful. This would not fix the COUNT problem but it would provide
the most essential information people need: The number of records in the
table.

Maybe this is worth discussing.

Regards,

Hans

--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>