pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Stark <gsstark@mit.edu>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: CHEWTC@ap.nec.com.sg
Cc: pgsql-performance@postgresql.org
Subject: Re: Minimum hardware requirements for Postgresql db
Date: 03 Dec 2003 14:23:32 -0500
Message-ID: <87smk166yz.fsf@stark.dyndns.tv> (raw)
In-Reply-To: <Pine.LNX.4.33.0312031122010.2226-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0312031122010.2226-100000@css120.ihs.com>


"scott.marlowe" <scott.marlowe@ihs.com> writes:

> > 3) Estimated number of transactions to be written into the Postgresql db is
> > around 15000 records per day.
> > 
> > The growth rate in terms of number of connections is around 10% per year
> > and the data retention is kept on average at least for 18 months for the 2
> > databases.

> Like another poster pointed out, this is a walk in the park for 
> postgresql.  My workstation (1.1GHz celeron, 40 gig IDE drive, 512 Meg 
> memory) could handle this load while still being my workstation.

Well there's some info missing. Like what would you actually be _doing_ with
these data?

15,000 inserts per day is nothing. But after 18 months that's over 5M records
not including the 10% growth rate. 5M records isn't really all that much but
it's enough that it's possible to write slow queries against it.

If you're doing big batch updates or complex reports against the data that
will be more interesting than the inserts.

-- 
greg




view thread (7+ messages)  latest in thread

Message-ID: <87smk166yz.fsf@stark.dyndns.tv>
Permalink:  ../87smk166yz.fsf@stark.dyndns.tv/
Also on:    postgresql.org/message-id/87smk166yz.fsf@stark.dyndns.tv

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsstark@mit.edu, scott.marlowe@ihs.com, CHEWTC@ap.nec.com.sg
  Subject: Re: Minimum hardware requirements for Postgresql db
  In-Reply-To: <87smk166yz.fsf@stark.dyndns.tv>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox