X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0E007474E4F for ; Fri, 7 Feb 2003 10:14:05 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 51084474E42 for ; Fri, 7 Feb 2003 10:14:04 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h17FDw5u026910; Fri, 7 Feb 2003 10:13:58 -0500 (EST) To: jeandre@itvs.co.za Cc: pgsql-performance@postgresql.org Subject: Re: Performance In-reply-to: References: Comments: In-reply-to jeandre@itvs.co.za message dated "Fri, 07 Feb 2003 17:04:52 +0200" Date: Fri, 07 Feb 2003 10:13:58 -0500 Message-ID: <26909.1044630838@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/36 X-Sequence-Number: 1092 jeandre@itvs.co.za writes: > In the documentation I saw something about different index types. In > Sybase you create an index and that is it. How do you choose what type of > index to create on a column in Postgres? There's an optional clause in the CREATE INDEX command --- I think "USING access_method", but check the man page. In practice, 99.44% of indexes are the default btree type, so you usually don't need to think about it. I'd only use a non-btree index if I needed to index non-scalar data (arrays, geometric types, etc); the GIST and RTREE index types are designed for those. regards, tom lane