Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group