Postgres Pro
Downloads
Home   >   mailing lists

Re: Partial indexes instead of partitions - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Partial indexes instead of partitions
Date
Msg-id AANLkTilVoQRBfAuXKm9fuAPph7JFTp-e0eu_qBnTn0t6@mail.gmail.com
Whole thread Raw
In response to Re: Partial indexes instead of partitions  (Leonardo F <m_lists@yahoo.it>)
List pgsql-general
Tree view 
On 14 June 2010 13:24, Leonardo F <m_lists@yahoo.it> wrote:
>> For "inserts" I do not see the reason
>> why
>> it would be better to use index partitioning because AFAIK
>> b-tree
>> would behave exactly the same in both cases.
>
> no, when the index gets very big inserting random values gets
> very slow.

Hm, interesting. Could you please provide some references/links?


--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Is there a way to backup Postgres via SQL commands?
Next
From: Frank Church
Date:
Subject: What are the minimal files required to backup a postgresql database