Postgres Pro
Downloads
Home   >   mailing lists

Re: Index over only uncommon values in table - Mailing list pgsql-general

From John R Pierce
Subject Re: Index over only uncommon values in table
Date
Msg-id 51C0B3AE.4020402@hogranch.com
Whole thread Raw
In response to Index over only uncommon values in table  (Steven Schlansker <steven@likeness.com>)
Responses Re: Index over only uncommon values in table  (Steven Schlansker <steven@likeness.com>)
List pgsql-general
Tree view 
On 6/18/2013 12:17 PM, Steven Schlansker wrote:
> 1) The common value is not known at schema definition time, and may change (very slowly) over time.

how could a value thats constant in 95% of the rows change, unless you
added 20 times more rows with a new value (and for a big portion of the
time, no value would meet your 95% criteria).

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Steven Schlansker
Date:
Subject: Index over only uncommon values in table
Next
From: Steve Crawford
Date:
Subject: Re: earthdistance compass bearing