Postgres Pro
Downloads
Home   >   mailing lists

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

From David Wilson
Subject Re: Partial indexes instead of partitions
Date
Msg-id AANLkTilByJyLgwXY7BLfLR8xv23MSb4TXCzjdlcW4emK@mail.gmail.com
Whole thread Raw
In response to Re: Partial indexes instead of partitions  (Peter Hunsberger <peter.hunsberger@gmail.com>)
List pgsql-general
Tree view


On Mon, Jun 14, 2010 at 8:38 AM, Peter Hunsberger <peter.hunsberger@gmail.com> wrote:


Can you define acceptable?  IIRC the OP is looking for 20,000+ inserts / sec.


He's actually only looking for 2k inserts/sec. With a battery backed controller I can sustain that, yes. That's also on commodity hardware (the whole system was under $2k a year and a half ago).


--
- David T. Wilson
david.t.wilson@gmail.com

pgsql-general by date:

Previous
From: Peter Hunsberger
Date:
Subject: Re: Partial indexes instead of partitions
Next
From: Alban Hertroys
Date:
Subject: Re: Is there a way to backup Postgres via SQL commands?