| From: | David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com> |
|---|---|
| To: | Peter Hunsberger <peter(dot)hunsberger(at)gmail(dot)com> |
| Cc: | Leonardo F <m_lists(at)yahoo(dot)it>, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Partial indexes instead of partitions |
| Date: | 2010-06-14 12:53:06 |
| Message-ID: | AANLkTilByJyLgwXY7BLfLR8xv23MSb4TXCzjdlcW4emK@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jun 14, 2010 at 8:38 AM, Peter Hunsberger <
peter(dot)hunsberger(at)gmail(dot)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(dot)t(dot)wilson(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2010-06-14 13:01:07 | Re: Is there a way to backup Postgres via SQL commands? |
| Previous Message | Peter Hunsberger | 2010-06-14 12:38:27 | Re: Partial indexes instead of partitions |