what index is faster to scan

From: Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: what index is faster to scan
Date: 2007-04-16 19:50:08
Message-ID: 4623D370.3090509@informatyka.gdansk.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kieran Cooper, Lyris UK 2007-04-16 21:51:41 Vacuum stops with misleading max_fsm_pages error
Previous Message Trula Thomas 2007-04-16 05:40:53 Cript for DISK SPACE USE psql