Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 55D7C9FA616 for ; Fri, 9 Feb 2007 20:05:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 79797-04 for ; Fri, 9 Feb 2007 20:05:45 -0400 (AST) X-Greylist: delayed 00:05:24.476158 by SQLgrey-1.7.4 Received: from mail.auptyma.com (mail.auptyma.com [64.60.124.12]) by postgresql.org (Postfix) with ESMTP id 2D7B49FA281 for ; Fri, 9 Feb 2007 20:05:48 -0400 (AST) Received: from demo01 (mail.auptyma.com [64.60.124.12] (may be forged)) (authenticated bits=0) by mail.auptyma.com (8.13.1/8.13.1) with ESMTP id l19NHRr2027709 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO) for ; Fri, 9 Feb 2007 15:17:27 -0800 Message-ID: <00aa01c74ca6$7392a160$2900000a@demo01> From: "Virag Saksena" To: Subject: Is there an equivalent for Oracle's user_tables.num_rows Date: Fri, 9 Feb 2007 16:00:18 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A7_01C74C63.64E9DDB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.7.5 (mail.auptyma.com [10.0.0.47]); Fri, 09 Feb 2007 15:17:27 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.2 tagged_above=0 required=5 tests=BAYES_40, HTML_MESSAGE, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200702/109 X-Sequence-Number: 23163 This is a multi-part message in MIME format. ------=_NextPart_000_00A7_01C74C63.64E9DDB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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.=20 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 ------=_NextPart_000_00A7_01C74C63.64E9DDB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

All,

I am looking to = automate analyze=20 table in my application.

I have some insert only tables in my = application=20 which I need to analyze as data grows.

Since the inserts are application = controlled, I can=20 choose to run analyze when I determine the

data has grown more than x% since last=20 analyze.

However since users can truncate the = tables too, I=20 need to be able to tell the numbers of rows

in the table as perceived by the = optimizer.=20

I could not decipher a good way of = telling the=20 number of table rows from pg_stats/pg_statistics.

Does someone know of a way of telling = what the=20 optimizer believes the number of rows are ?

The tables in question have = multi-column primary=20 keys.

Regards,

Virag

------=_NextPart_000_00A7_01C74C63.64E9DDB0--