pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
what index is faster to scan
2+ messages / 1 participants
[nested] [flat]

* what index is faster to scan
@ 2007-04-16 19:50 Adam Radłowski <adamr@informatyka.gdansk.pl>
  2007-04-17 18:48 ` Re: what index is faster to scan Adam Radłowski <adamr@informatyka.gdansk.pl>
  0 siblings, 1 reply; 2+ messages in thread

From: Adam Radłowski @ 2007-04-16 19:50 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: what index is faster to scan
  2007-04-16 19:50 what index is faster to scan Adam Radłowski <adamr@informatyka.gdansk.pl>
@ 2007-04-17 18:48 ` Adam Radłowski <adamr@informatyka.gdansk.pl>
  0 siblings, 0 replies; 2+ messages in thread

From: Adam Radłowski @ 2007-04-17 18:48 UTC (permalink / raw)
  To: Adam Radłowski <adamr@informatyka.gdansk.pl>; +Cc: 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
> 
> 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-04-17 18:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-16 19:50 what index is faster to scan Adam Radłowski <adamr@informatyka.gdansk.pl>
2007-04-17 18:48 ` Adam Radłowski <adamr@informatyka.gdansk.pl>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox