Re: [PERFORM] Is there an equivalent for Oracle's user_tables.num_rows

2007-02-09 Thread Virag Saksena
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

Re: [PERFORM] Is there an equivalent for Oracle's user_tables.num_rows

2007-02-09 Thread Tom Lane
"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

[PERFORM] Is there an equivalent for Oracle's user_tables.num_rows

2007-02-09 Thread Virag Saksena
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