Re: A question on performance

On Mon, 16 Sep 2002, Andrew Sullivan wrote:

> On Fri, Sep 13, 2002 at 03:33:01AM +0000, Ron Harter wrote:
>
> > loadings and average sizes we can except anywhere from 700 to 900 updates
> > per second.
>
> > Will postgresql be able to handle that many updates per second an a
> > sustained basis (24/7)?
>
> You don't say what hardware you're planning on using. So a definite
> "maybe". If your disk is fast enough and you have enough CPUs, you
> should be able to handle it without too much trouble. But if you're
> planning on running it on an old Pentium box with 16 Meg of memory,
> you'll have a rough time ;-)

Plus, if they're updates, not inserts, he's gonna need to schedule a
vacuum to run almost continuously in the background. And he might wanna
look at moving the pg_xlog directory to another drive