Re: performance problems inserting random vals in index - Mailing list pgsql-general

From Leonardo F
Subject Re: performance problems inserting random vals in index
Date
Msg-id 655851.114.qm@web29001.mail.ird.yahoo.com
Whole thread Raw
In response to Re: performance problems inserting random vals in index  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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




pgsql-general by date:

Previous
From: Leonardo F
Date:
Subject: Re: performance problems inserting random vals in index
Next
From: Leonardo F
Date:
Subject: Re: performance problems inserting random vals in index