Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E91549FB2F9 for ; Mon, 16 Apr 2007 16:51:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 45125-05 for ; Mon, 16 Apr 2007 16:51:08 -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 B86289FA502 for ; Mon, 16 Apr 2007 16:51:09 -0300 (ADT) Received: (qmail 16909 invoked by uid 540); 16 Apr 2007 19:48:07 -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.080114 secs); 16 Apr 2007 19:48:07 -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; 16 Apr 2007 19:48:07 -0000 Message-ID: <4623D370.3090509@informatyka.gdansk.pl> Date: Mon, 16 Apr 2007 21:50:08 +0200 From: =?ISO-8859-2?Q?Adam_Rad=B3owski?= User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: what index is faster to scan Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/141 X-Sequence-Number: 25205 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