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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Dolafi, Tom" <dolafit@xxxxxxxxxxxxxxxx>
Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 29 Jun 2007 14:30:09 -0400
Cc: "Craig James" <craig_james@xxxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Dolafi, Tom" <dolafit@xxxxxxxxxxxxxxxx> message dated "Fri, 29 Jun 2007 14:05:30 -0400"
In-reply-to: <AE9860225100F14D87B26D0D4D6766DB46F42B@xxxxxxxxxxxxxxxxxxxxxxx>
References: <AE9860225100F14D87B26D0D4D6766DB46F246@xxxxxxxxxxxxxxxxxxxxxxx> <13616.1183046917@xxxxxxxxxxxxx> <AE9860225100F14D87B26D0D4D6766DB46F3E7@xxxxxxxxxxxxxxxxxxxxxxx> <46852FD0.2030306@xxxxxxxxxxxxxx> <AE9860225100F14D87B26D0D4D6766DB46F42B@xxxxxxxxxxxxxxxxxxxxxxx>

"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

Follow-Ups:
- Re: rtree/gist index taking enormous amount of space in 8.2.3
  - From: Dolafi, Tom

References:
- rtree/gist index taking enormous amount of space in 8.2.3
  - From: Dolafi, Tom
- Re: rtree/gist index taking enormous amount of space in 8.2.3
  - From: Tom Lane
- Re: rtree/gist index taking enormous amount of space in 8.2.3
  - From: Dolafi, Tom
- Re: rtree/gist index taking enormous amount of space in 8.2.3
  - From: Craig James
- Re: rtree/gist index taking enormous amount of space in 8.2.3
  - From: Dolafi, Tom

Prev by Date: Re: rtree/gist index taking enormous amount of space in 8.2.3
Next by Date: Re: rtree/gist index taking enormous amount of space in 8.2.3
Previous by thread: Re: rtree/gist index taking enormous amount of space in 8.2.3
Next by thread: Re: rtree/gist index taking enormous amount of space in 8.2.3
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]