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

Re: what index is faster to scan

From: Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: what index is faster to scan
Date: 2007-04-17 18:48:29
Message-ID: 4625167D.8060206@informatyka.gdansk.pl (view raw or flat)
Thread:
Lists: pgsql-admin
Sorry for question. I've tested it by myself. There is no significant 
differences.
Adam

Adam Radłowski napisał(a):
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>               http://archives.postgresql.org
> 
> 

In response to

pgsql-admin by date

Next:From: Alexander B.Date: 2007-04-17 19:17:36
Subject: Return data from function
Previous:From: Tom LaneDate: 2007-04-17 17:23:49
Subject: Re: Lock file conflict with multiple postmasters

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