Re: performance problems inserting random vals in index

From: Leonardo F <m_lists(at)yahoo(dot)it>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: performance problems inserting random vals in index
Date: 2010-04-20 06:51:01
Message-ID: 655851.114.qm@web29001.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On a few very narrow applications I've gotten good
> performance in the
> low hundreds. After that things fall apart
> quickly.

Ehm... what exactly "fall apart quickly" means?
I can trade some "select" speed for "insert" speed...

I don't have experience with partitioning, if some of
you already know what's going to happen I could
avoid testing or at least testing for the wrong setup...

Thank you

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo F 2010-04-20 06:52:43 Re: performance problems inserting random vals in index
Previous Message Leonardo F 2010-04-20 06:46:58 Re: performance problems inserting random vals in index