Skip site navigation (1) Skip section navigation (2)

Re: performance issues for processing more then 150000 records / day.

From: "Jakab Laszlo" <jakablaszlo(at)sofasoft(dot)ro>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance issues for processing more then 150000 records / day.
Date: 2003-02-21 08:33:42
Message-ID: 007c01c2d983$f3d60d70$0900000a@new (view raw or flat)
Thread:
Lists: pgsql-performance
Hello Chris,

I mean here 150000 inserts/day ( quickly grows constantly )...  - with transactions and on the same table ... maybe after one significant amount of time we can move the records of one year to one archive table ...
And some 2-3 millions of selects / day ... 

I would like to know also some hardware related advice.

thanks,
Jaki
  ----- Original Message ----- 
  From: Christopher Kings-Lynne 
  To: Jakab Laszlo ; pgsql-performance(at)postgresql(dot)org 
  Sent: Friday, February 21, 2003 10:04 AM
  Subject: Re: [PERFORM] performance issues for processing more then 150000 records / day.


  Hi Jakab,
   
  I don't see why postgresql wouldn't be able to handle that - it's a relatively small amount of data.
   
  When you say 150000 records/day, do you mean:
   
  1. 150000 inserts/day (ie. database grows constantly, quickly)
  2. 150000 updates/deletes/day
  3. 150000 transactions/select/day
   
  If you give us a little more information, we'll be able to help you tune your postgres for your application.
   
  Regards,
   
  Chris

    ----- Original Message ----- 
    From: Jakab Laszlo 
    To: pgsql-performance(at)postgresql(dot)org 
    Sent: Friday, February 21, 2003 3:48 PM
    Subject: [PERFORM] performance issues for processing more then 150000 records / day.


    Hello,

    We would like to use PostgreSQL for one project.
    This project would need to handle some of 150000 - 200000 (thousands records) per day.

    Is there somebody having experience with Postgresql in this kind of environment.
    Can anybody advice us regarding specific PostgreSQL issues for such kind of datamanipulation ?

    Best Regards,
    Jaki

In response to

Responses

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2003-02-21 08:42:25
Subject: Re: performance issues for processing more then 150000 records / day.
Previous:From: Christopher Kings-LynneDate: 2003-02-21 08:04:52
Subject: Re: performance issues for processing more then 150000 records / day.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group