> 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.
PostgreSQL Experts Inc.
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2012-01-09 19:59:08|
|Subject: Re: Moving more work outside WALInsertLock|
|Previous:||From: Josh Berkus||Date: 2012-01-09 19:05:40|
|Subject: Re: Why is CF 2011-11 still listed as "In Progress"?|