From: Virag Saksena <virag@auptyma.com>
To: pgsql-performance@postgresql.org
Subject: Is there an equivalent for Oracle's user_tables.num_rows
Date: Fri, 9 Feb 2007 16:00:18 -0800
Message-ID: <00aa01c74ca6$7392a160$2900000a@demo01> (raw)
All,
I am looking to automate analyze table in my application.
I have some insert only tables in my application which I need to analyze as data grows.
Since the inserts are application controlled, I can choose to run analyze when I determine the
data has grown more than x% since last analyze.
However since users can truncate the tables too, I need to be able to tell the numbers of rows
in the table as perceived by the optimizer.
I could not decipher a good way of telling the number of table rows from pg_stats/pg_statistics.
Does someone know of a way of telling what the optimizer believes the number of rows are ?
The tables in question have multi-column primary keys.
Regards,
Virag
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: virag@auptyma.com
Subject: Re: Is there an equivalent for Oracle's user_tables.num_rows
In-Reply-To: <00aa01c74ca6$7392a160$2900000a@demo01>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox