Re: Optimize update query

From: Willem Leenen <willem_leenen(at)hotmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Optimize update query
Date: 2012-11-28 15:11:46
Message-ID: DUB104-W48E83E17609D570C42B5AD8F5D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I assume that SQL databases ( Banks? Telecom?) can handle an used car shop. No need for an unstructured data tool.

> +1, sql databases has limited number of inserts/updates per second. Even
> with highend hardware you won't have more than XXX operations per
> second. As Thomas said, you should feed something like nosql database
> from www server and use other tool to do aggregation and batch inserts
> to postgresql. It will scale much better.
>
> Marcin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Blackwell 2012-11-28 15:18:20 Re: Savepoints in transactions for speed?
Previous Message Kevin Grittner 2012-11-28 14:51:26 Re: Optimize update query