CTED]>
To: "Virag Saksena" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, February 09, 2007 4:45 PM
Subject: Re: [PERFORM] Is there an equivalent for Oracle's
user_tables.num_rows
"Virag Saksena" <[EMAIL PROTECTED]> writes:
Does someone know of a way of te
"Virag Saksena" <[EMAIL PROTECTED]> writes:
> Does someone know of a way of telling what the optimizer believes the =
> number of rows are ?
You're looking in the wrong place; see pg_class.relpages and reltuples.
But note that in recent releases neither one is taken as gospel.
Instead the planner
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