Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to have a "fast-write" Index? - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Is it possible to have a "fast-write" Index?
Date
Msg-id 558320E5.5020100@BlueTreble.com
Whole thread Raw
In response to Re: Is it possible to have a "fast-write" Index?  (deavid <deavidsedice@gmail.com>)
List pgsql-hackers
Tree view 
On 6/12/15 9:17 PM, deavid wrote:
>    (upper(codagencia::text) );

FWIW, you should consider using citext for these cases; it would let you 
cut down on the number of indexes (by 50%?).
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-hackers by date:

Previous
From: deavid
Date:
Subject: Re: Is it possible to have a "fast-write" Index?
Next
From: Tom Lane
Date:
Subject: Re: Inheritance planner CPU and memory usage change since 9.3.2