X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 94A7811F68C6 for ; Thu, 20 Apr 2006 12:17:10 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.385 X-Spam-Level: * X-Spam-Status: No, score=1.385 required=5 tests=[AWL=0.132, RCVD_NUMERIC_HELO=1.253] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id rgDbJ67XfJmh for ; Thu, 20 Apr 2006 12:16:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id 985C911F66E4 for ; Thu, 20 Apr 2006 12:16:57 -0300 (ADT) Received: from 172.16.1.110 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Thu, 20 Apr 2006 11:16:43 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 20 Apr 2006 11:16:37 -0400 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Thu, 20 Apr 2006 15:16:36 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Thu, 20 Apr 2006 08:16:34 -0700 Subject: Re: Quick Performance Poll From: "Luke Lonergan" To: "Markus Schaber" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Quick Performance Poll Thread-Index: AcZkjP+AZOTZE0eRRjCh9XsBHBqhrAAAGlqf In-Reply-To: <4447A49D.9080707@logix-tt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 20 Apr 2006 15:16:37.0504 (UTC) FILETIME=[6B012000:01C6648D] X-WSS-ID: 68597A454N02565566-13-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/455 X-Sequence-Number: 18539 Markus, On 4/20/06 8:11 AM, "Markus Schaber" 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