Neil Conway wrote:
On Sun, 2003-02-02 at 03:55, Hans-Jürgen Schönig wrote: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.
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
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>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
