pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: performance issues for processing more then 150000 records / day.
Date: Fri, 21 Feb 2003 14:12:25 +0530
Message-ID: <3E5633C9.27527.439F17A@localhost> (raw)
In-Reply-To: <007c01c2d983$f3d60d70$0900000a@new>

On 21 Feb 2003 at 10:33, Jakab Laszlo wrote:

> 
> Hello Chris,
> 
> I mean here 150000 inserts/day ( quickly grows constantly )... - with 
> transactions and on the same table ... maybe after onesignificant amount of 
> time we can move the records of one year to one archivetable ...
> Andsome 2-3 millions of selects / day ... 
> 
> I would like to know also some hardware related advice.

Use a 64 bit machine with SCSI, preferrably RAID to start with. You can search 
list archives for similar problems and solutions.

HTH

Bye
 Shridhar

--
Fog Lamps, n.:	Excessively (often obnoxiously) bright lamps mounted on the 
fronts	of automobiles; used on dry, clear nights to indicate that the	driver's 
brain is in a fog.  See also "Idiot Lights".




view thread (8+ messages)  latest in thread

Message-ID: <3E5633C9.27527.439F17A@localhost>
Permalink:  ../3E5633C9.27527.439F17A@localhost/
Also on:    postgresql.org/message-id/3E5633C9.27527.439F17A@localhost

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: performance issues for processing more then 150000 records / day.
  In-Reply-To: <3E5633C9.27527.439F17A@localhost>
  References: <007c01c2d983$f3d60d70$0900000a@new> <3E5633C9.27527.439F17A@localhost>

* 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