On Monday 10 April 2006 15:37, Andreas Pflug wrote:
> Always stay on the list, private mail frequently gets dropped!!!
Yeah, my mistake :)
>
> > The table contains 0 rows, but there are several tables that inherit from
> > this one. And those table contain the real rows.
>
> Ok, you didn't mention
Always stay on the list, private mail frequently gets dropped!!!
The table contains 0 rows, but there are several tables that inherit from this
one. And those table contain the real rows.
Ok, you didn't mention inheritance, now I see the problem.
There's only the solution to set the option "
Marc Cousin wrote:
all the databases of the cluster are regularly vacuumed (at least once a day),
all the stats are up to date.
If stats say 0 ("estimated rows") rows but 40M rows are present stats
are clearly not up-to-date. We had interpretation problems of
pg_class.reltuples because it was r
On Monday 10 April 2006 15:18, you wrote:
> Marc Cousin wrote:
> > all the databases of the cluster are regularly vacuumed (at least once a
> > day), all the stats are up to date.
>
> If stats say 0 ("estimated rows") rows but 40M rows are present stats
> are clearly not up-to-date. We had interpre
all the databases of the cluster are regularly vacuumed (at least once a day),
all the stats are up to date.
what i'm talking about is a partitionned table (8.1, with constraint
exclusions), a 'main' table empty, and a dozen of inherited tables, which
contain the real data. The main table conta
Marc Cousin wrote:
Hi,
I've got a partitionned table with PG 8.1, and I'm using pgadmin3 1.4.1.
I'm having problems using pgadmin because it tries to count the elements of
the partitionned table...
The main table contains 0 record (so the stats say 0), so pgadmin decides it
can count all the
Hi,
I've got a partitionned table with PG 8.1, and I'm using pgadmin3 1.4.1.
I'm having problems using pgadmin because it tries to count the elements of
the partitionned table...
The main table contains 0 record (so the stats say 0), so pgadmin decides it
can count all the elements from the tab
