Re: Optimize update query - Mailing list pgsql-performance

From Willem Leenen
Subject Re: Optimize update query
Date
Msg-id DUB104-W48E83E17609D570C42B5AD8F5D0@phx.gbl
Whole thread Raw
In response to Re: Optimize update query  (Marcin Mirosław <marcin@mejor.pl>)
Responses Re: Optimize update query  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
List 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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Optimize update query
Next
From: Mike Blackwell
Date:
Subject: Re: Savepoints in transactions for speed?