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