(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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
