Inconsistent result from request

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

Browse pgsql-admin by date

  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