From: Luke Lonergan <llonergan@greenplum.com>
To: Markus Schaber <schabi@logix-tt.com>
To: pgsql-performance@postgresql.org
Subject: Re: Quick Performance Poll
Date: Thu, 20 Apr 2006 08:16:34 -0700
Message-ID: <C06CF3E2.21E3D%llonergan@greenplum.com> (raw)
In-Reply-To: <4447A49D.9080707@logix-tt.com>
Markus,
On 4/20/06 8:11 AM, "Markus Schaber" <schabi@logix-tt.com> wrote:
> Are they capable to index custom datatypes like the PostGIS geometries
> that use the GIST mechanism? This could probably speed up our Geo
> Databases for Map rendering, containing static data that is updated
> approx. 2 times per year.
Should work fine - the other limitation is cardinality, or number of unique
values in the column being indexed. A reasonable limit is about 10,000
unique values in the column.
We're also going to improve this aspect of the implementation, but the
progress might take the useful limit to 300,000 or so.
- Luke
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: llonergan@greenplum.com, schabi@logix-tt.com
Subject: Re: Quick Performance Poll
In-Reply-To: <C06CF3E2.21E3D%llonergan@greenplum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox