Thank you for the patch. The index size is back down to 500MB and there
are no performance issues with queries against the table.
-Original Message-
From: Teodor Sigaev [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 8:08 AM
To: Tom Lane
Cc: Dolafi, Tom; pgsql-performance
on queries against the table, but we have not tested
the part of the application which would utilize this index.
- Tom
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, June 29, 2007 1:58 PM
To: Dolafi, Tom
Cc: pgsql-performance@postgresql.org; Oleg Bartunov; Teo
-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, June 29, 2007 2:38 PM
To: Dolafi, Tom
Cc: pgsql-performance@postgresql.org; Oleg Bartunov; Teodor Sigaev
Subject: Re: [PERFORM] rtree/gist index taking enormous amount of space
in 8.2.3
"Dolafi, Tom" <[EMAIL PROTECTED]>
ogus" 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 i
9484598 |212
Also, out of 5.7 million rows there are 1.6 million unique fmin and 1.6
million unique fmax values.
Thanks,
Tom
-Original Message-
From: Craig James [mailto:[EMAIL PROTECTED]
Sent: Friday, June 29, 2007 12:14 PM
To: Dolafi, Tom
Cc: Tom Lane; pgsql-performance
the two constants seem to represent the notion of infinity.
Thanks,
Tom
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 12:09 PM
To: Dolafi, Tom
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] rtree/gist index taking enormous amount of
Hi,
In version 8.1.5, I have an rtree index on a 1.5 GB table. The size of
this index is 500 MB. After migrating to 8.2.3, the size of this index
has increased to 35GB. I've dropped are recreated the index and got the
same result. In 8.2.3 the index type is gist, does this have something
to
