| From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
|---|---|
| To: | "Markus Schaber" <schabi(at)logix-tt(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Quick Performance Poll |
| Date: | 2006-04-20 15:16:34 |
| Message-ID: | C06CF3E2.21E3D%llonergan@greenplum.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Markus,
On 4/20/06 8:11 AM, "Markus Schaber" <schabi(at)logix-tt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radovan Antloga | 2006-04-20 15:20:56 | Performance decrease |
| Previous Message | Gavin Hamill | 2006-04-20 15:13:49 | IBM pSeries - overrated bucket of crud? |