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

Re: Progress on fast path sorting, btree index creation time

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Progress on fast path sorting, btree index creation time
Date: 2012-01-09 19:45:39
Message-ID: 4F0B43E3.30207@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> Obviously, many indexes are unique and thus won't have duplicates at
> all.  But if someone creates an index and doesn't make it unique, odds
> are very high that it has some duplicates.  Not sure how many we
> typically expect to see, but more than zero...

Peter may not, but I personally admin lots of databases which have
indexes on values like "category" or "city" which have 100's or 1000's
of duplicates per value.  I don't think this is uncommon at all.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2012-01-09 19:59:08
Subject: Re: Moving more work outside WALInsertLock
Previous:From: Josh BerkusDate: 2012-01-09 19:05:40
Subject: Re: Why is CF 2011-11 still listed as "In Progress"?

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