| From: | James Mansion <james(at)mansionfamily(dot)plus(dot)com> |
|---|---|
| To: | Matthew Wakeling <matthew(at)flymine(dot)org> |
| Cc: | andrew klassen <aptklassen(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: insert/update tps slow with indices on table > 1M rows |
| Date: | 2008-06-04 20:15:45 |
| Message-ID: | 4846F7F1.1050408@mansionfamily.plus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Matthew Wakeling wrote:
> If you're running a "work queue" architecture, that probably means you
> only have one thread doing all the updates/inserts? It might be worth
> going multi-threaded, and issuing inserts and updates through more
> than one connection. Postgres is designed pretty well to scale
> performance by the number of simultaneous connections.
That would explain a disappointing upper limit on insert rate, but not
any sort of cliff for the rate. Nor, really, any material slowdown, if
the single thread implies that we're stuck on round trip latency as a
material limiting factor.
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Mansion | 2008-06-04 20:20:26 | Re: insert/update tps slow with indices on table > 1M rows |
| Previous Message | andrew klassen | 2008-06-04 17:24:09 | Re: insert/update tps slow with indices on table > 1M rows |