Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id C3B7A9FBA70
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Jun 2007 11:45:17 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 34106-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Jun 2007 11:44:26 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.251])
	by postgresql.org (Postfix) with ESMTP id 30B8E9FB973
	for <pgsql-sql@postgresql.org>; Mon, 11 Jun 2007 11:44:35 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so834551ana
	for <pgsql-sql@postgresql.org>; Mon, 11 Jun 2007 07:44:33 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=ANvpBduD1RJM/Oovbejx+EDM7mUBaU23bc0vqViMR4gR6JrmX9ydKRX1u679cM2ptpdMWMa7jds/RawKjIjGaNg683spCFe7bDZn6z0p+ZPPwAu4tStxFREwi0H1JavVnnYyaOQXnr5QQNdaGv/7h5CVf8kfNEiTbGlqjmfEpc0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=AfDiPie5nBtVABra54Yd4DbYyWOGYDdfyFbQ+WlyK7/XytQ4qCL+CYI5FzNTHlt1aZ3Caqc/pO9JMws9kz0VDeLfLOxxw0PqMwz8maRF2rgGNhMh/9dQy2tyv5YUldpy9qyMjJhbaUrAib5FlSnV7ZYAM9ZNZTME3pthqd3DWEU=
Received: by 10.100.59.20 with SMTP id h20mr3351168ana.1181573073843;
	Mon, 11 Jun 2007 07:44:33 -0700 (PDT)
Received: by 10.100.33.20 with HTTP; Mon, 11 Jun 2007 07:44:33 -0700 (PDT)
Message-ID: <a55915760706110744t7eaeaad0w4556a56881109ae2@mail.gmail.com>
Date: Mon, 11 Jun 2007 09:44:33 -0500
From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org, "Sabin Coanda" <sabin.coanda@deuromedia.ro>
Subject: Re: cluster index on primary key
In-Reply-To: <f4jmaj$vaq$1@news.hub.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <f4jmaj$vaq$1@news.hub.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/82
X-Sequence-Number: 28572

On 6/11/07, Sabin Coanda <sabin.coanda@deuromedia.ro> wrote:
> I'd like to know when I create a primary key on a table, does postgres will
> create automatically an index on that table related to the primary key
> columns, or I have to create it explicitly ?