Re: pg_stats.avg_width differs by a factor of 4 on different machines

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig de Stigter <craig(dot)destigter(at)koordinates(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_stats.avg_width differs by a factor of 4 on different machines
Date: 2009-06-02 00:30:48
Message-ID: 29077.1243902648@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig de Stigter <craig(dot)destigter(at)koordinates(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Smith 2009-06-02 01:26:45 Re: newbie table design question
Previous Message Craig de Stigter 2009-06-01 23:57:24 Re: pg_stats.avg_width differs by a factor of 4 on different machines