(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@xxxxxxxxxxxxx] Sent: Friday, June 29, 2007 2:30 PM To: Dolafi, Tom Cc: Craig James; pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] rtree/gist index taking enormous amount of space in 8.2.3 "Dolafi, Tom" <dolafit@xxxxxxxxxxxxxxxx> 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
