(fmax-fmin)...
min | max | avg
---------+---------+----------------------
1 | 2278225 | 546
I noticed 3000 occurrences where fmax is less than fmin. I excluded
these values to get the min difference between the two. Also, there are
20 "invalid"/"bogus" rows with negative values which were excluded from
the queries.
Thanks,
Tom
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, June 29, 2007 2:30 PM
To: Dolafi, Tom
Cc: Craig James; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] rtree/gist index taking enormous amount of space
in 8.2.3
"Dolafi, Tom" <dolafit@janelia.hhmi.org> writes:
> The data is not distributed well...
Can you show us min, max, and avg of fmax minus fmin? I'd like to
check my guess about that being a fairly narrow range.
regards, tom lane