Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 21C739FB435 for ; Tue, 17 Apr 2007 15:49:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 69258-05 for ; Tue, 17 Apr 2007 15:49:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id C54A69FB592 for ; Tue, 17 Apr 2007 15:49:30 -0300 (ADT) Received: (qmail 3036 invoked by uid 540); 17 Apr 2007 18:46:31 -0000 Received: from 83.143.210.69 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(83.143.210.69):. Processed in 0.074803 secs); 17 Apr 2007 18:46:31 -0000 Received: from host69-83-143-210.limes.com.pl (HELO ?10.0.1.69?) (informatyka-adamr@83.143.210.69) by ns1.peker.com.pl with SMTP; 17 Apr 2007 18:46:31 -0000 Message-ID: <4625167D.8060206@informatyka.gdansk.pl> Date: Tue, 17 Apr 2007 20:48:29 +0200 From: =?ISO-8859-2?Q?Adam_Rad=B3owski?= User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: =?ISO-8859-2?Q?Adam_Rad=B3owski?= CC: pgsql-admin@postgresql.org Subject: Re: what index is faster to scan References: <4623D370.3090509@informatyka.gdansk.pl> In-Reply-To: <4623D370.3090509@informatyka.gdansk.pl> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/157 X-Sequence-Number: 25221 Sorry for question. I've tested it by myself. There is no significant differences. Adam Adam Radłowski napisał(a): > Hello! > I'm thinking about two things: > 1. what index is faster to scan (for select ... where statements) unique > or not unique ? > 2. can the unique index to slow inserts commands (in comparison with not > unique index) ? > Best regards > Adam > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > >