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: (view raw or whole thread)
Lists: pgsql-admin
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


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-2015 The PostgreSQL Global Development Group