From: | "Patrick De Zlio" <pchemla01(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Inconsistent result from request |
Date: | 2007-10-14 14:41:51 |
Message-ID: | 58729a240710140741r6384478evb2a7d732804fd9e1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi listers,
As a PG administrator, I'm trying to read technical data from pg_class table
to monitor tables and indexes space.
We are running a quite big postgres platform, with multiple databases,
multiples schemes in each database, and hundreds tables.
When I run the attach python script, I get 1809 rows as result. When I run
the included (from the script) select query from phpPgAdmin or pgAdmin III,
I get 2010 rows as result.
When I try to focus on specific table including where relname ='tablename'
in both parts of the join, I also get different numbers of rows. So I can't
have the full size of all indexes attached on a table.
Does anyone has a clue of why the same query, on same database gives
different result depending on it is included in a python script, or ran from
a console?
Many Thanks
Patrick
Attachment | Content-Type | Size |
---|---|---|
pgtables.py | text/x-python | 1.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Martial Elisée Wendbé KIBA | 2007-10-14 20:53:47 | Distributed DataBases |
Previous Message | Brad King | 2007-10-13 17:19:20 | Partitioning and deadlocks |