Home > mailing lists

what index is faster to scan - Mailing list pgsql-admin

From	Adam Radłowski
Subject	what index is faster to scan
Date	April 16, 2007 16:51:15
Msg-id	4623D370.3090509@informatyka.gdansk.pl Whole thread Raw
Responses	Re: what index is faster to scan
List	pgsql-admin

Tree view

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

pgsql-admin by date:

From: "Trula Thomas"
Date: 16 April 2007, 14:36:23
Subject: Cript for DISK SPACE USE psql

From: "Kieran Cooper, Lyris UK"
Date: 16 April 2007, 18:59:48
Subject: Vacuum stops with misleading max_fsm_pages error

what index is faster to scan - Mailing list pgsql-admin

Previous

Next