Skip site navigation (1) Skip section navigation (2)

Re: rtree/gist index taking enormous amount of space in 8.2.3

From: "Dolafi, Tom" <dolafit(at)janelia(dot)hhmi(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Craig James" <craig_james(at)emolecules(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3
Date: 2007-06-29 18:44:31
Message-ID: AE9860225100F14D87B26D0D4D6766DB46F434@EXCHANGE03.janelia.priv (view raw or flat)
Thread:
Lists: pgsql-performance
(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(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Friday, June 29, 2007 2:30 PM
To: Dolafi, Tom
Cc: Craig James; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] rtree/gist index taking enormous amount of space
in 8.2.3 

"Dolafi, Tom" <dolafit(at)janelia(dot)hhmi(dot)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

In response to

pgsql-performance by date

Next:From: Dolafi, TomDate: 2007-06-29 19:40:30
Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3
Previous:From: Tom LaneDate: 2007-06-29 18:38:11
Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group