Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_stats.avg_width differs by a factor of 4 on different machines - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_stats.avg_width differs by a factor of 4 on different machines
Date
Msg-id 29077.1243902648@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_stats.avg_width differs by a factor of 4 on different machines  (Craig de Stigter <craig.destigter@koordinates.com>)
List pgsql-general
Tree view 
Craig de Stigter <craig.destigter@koordinates.com> writes:
> Does anyone have any idea why these numbers would be 4 times as big in
> Postgres 8.3.7 ?

It still doesn't make any sense to me that you're getting values larger
than the BLCKSZ.  If you look into where that's coming from you might
get a clue what's up with the version difference.

            regards, tom lane

pgsql-general by date:

Previous
From: Craig de Stigter
Date:
Subject: Re: pg_stats.avg_width differs by a factor of 4 on different machines
Next
From: Andrew Smith
Date:
Subject: Re: newbie table design question