Postgres Pro
Downloads
Home   >   mailing lists

Re: Fast insertion indexes: why no developments - Mailing list pgsql-hackers

From Jeremy Harris
Subject Re: Fast insertion indexes: why no developments
Date
Msg-id 52836058.6030308@wizmail.org
Whole thread Raw
In response to Re: Fast insertion indexes: why no developments  (Leonardo Francalanci <m_lists@yahoo.it>)
Responses Re: Fast insertion indexes: why no developments
List pgsql-hackers
Tree view 
On 13/11/13 09:07, Leonardo Francalanci wrote:
> Problem? having 4 btree indexes on random values (imsi+imei * 2,
> since we have calling and caller) kills the performance in insertion
> after a while.

Surely there's good correlation between IMSI & IMEI, so have a separate
table to translate one to (a group of) the others, and
halve the indexes on your main table?
-- 
Jeremy

pgsql-hackers by date:

Previous
From: Sawada Masahiko
Date:
Subject: The number of character limitation of custom script on pgbench
Next
From: Peter Eisentraut
Date:
Subject: Re: patch to fix unused variable warning on windows build