X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D0789475AEC for ; Fri, 21 Feb 2003 03:30:16 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 48857-03 for ; Fri, 21 Feb 2003 03:30:05 -0500 (EST) Received: from saturn.hiddenservers.com (saturn.hiddenservers.com [209.123.207.12]) by postgresql.org (Postfix) with ESMTP id A6BAA474E61 for ; Fri, 21 Feb 2003 03:28:45 -0500 (EST) Received: from [213.154.101.33] (helo=new) by saturn.hiddenservers.com with smtp (Exim 3.36 #1) id 18m8Y5-0000vv-00; Fri, 21 Feb 2003 03:28:49 -0500 Message-ID: <007c01c2d983$f3d60d70$0900000a@new> From: "Jakab Laszlo" To: "Christopher Kings-Lynne" , References: <004501c2d97d$98927670$0900000a@new> <0a6901c2d97f$ea1369d0$6500a8c0@fhp.internal> Subject: Re: performance issues for processing more then 150000 records / day. Date: Fri, 21 Feb 2003 10:33:42 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0079_01C2D994.B49FE480" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - saturn.hiddenservers.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [0 0] X-AntiAbuse: Sender Address Domain - sofasoft.ro X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/145 X-Sequence-Number: 1201 This is a multi-part message in MIME format. ------=_NextPart_000_0079_01C2D994.B49FE480 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello Chris, I mean here 150000 inserts/day ( quickly grows constantly )... - with tran= sactions and on the same table ... maybe after one significant amount of ti= me we can move the records of one year to one archive table ... And some 2-3 millions of selects / day ...=20 I would like to know also some hardware related advice. thanks, Jaki ----- Original Message -----=20 From: Christopher Kings-Lynne=20 To: Jakab Laszlo ; pgsql-performance@postgresql.org=20 Sent: Friday, February 21, 2003 10:04 AM Subject: Re: [PERFORM] performance issues for processing more then 150000= records / day. Hi Jakab, =20=20=20 I don't see why postgresql wouldn't be able to handle that - it's a relat= ively small amount of data. =20=20=20 When you say 150000 records/day, do you mean: =20=20=20 1. 150000 inserts/day (ie. database grows constantly, quickly) 2. 150000 updates/deletes/day 3. 150000 transactions/select/day =20=20=20 If you give us a little more information, we'll be able to help you tune = your postgres for your application. =20=20=20 Regards, =20=20=20 Chris ----- Original Message -----=20 From: Jakab Laszlo=20 To: pgsql-performance@postgresql.org=20 Sent: Friday, February 21, 2003 3:48 PM Subject: [PERFORM] performance issues for processing more then 150000 r= ecords / day. Hello, We would like to use PostgreSQL for one project. This project would need to handle some of 150000 - 200000 (thousands re= cords) per day. Is there somebody having experience with Postgresql in this kind of env= ironment. Can anybody advice us regarding specific PostgreSQL issues for such kin= d of datamanipulation ? Best Regards, Jaki ------=_NextPart_000_0079_01C2D994.B49FE480 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello Chris,
 
I mean here 150000 inserts/day ( quickly g= rows=20 constantly )...  - with transactions and on the same table ... maybe a= fter=20 one significant amount of time we can move the records of one year to = one=20 archive table ...
And some 2-3 millions of selects / da= y ...=20
 
I would like to know also some hardware re= lated=20 advice.
 
thanks,
Jaki
----- Original Message -----
Fro= m:=20 Christopher Kings-Lynne
To: J= akab=20 Laszlo ; pgsql-performance@postgresql.org= =20
Sent: Friday, February 21, 2003 10= :04=20 AM
Subject: Re: [PERFORM] performance= issues=20 for processing more then 150000 records / day.

Hi Jakab,
 
I don't see why postgresql wouldn't be a= ble to=20 handle that - it's a relatively small amount of data.
 
When you say 150000 records/day, do you= =20 mean:
 
1. 150000 inserts/day (ie. database grow= s=20 constantly, quickly)
2. 150000 updates/deletes/day
3. 150000 transactions/select/day=
 
If you give us a little more information= , we'll=20 be able to help you tune your postgres for your application.
 
Regards,
 
Chris
 
----- Original Message -----
F= rom:=20 Jakab=20 Laszlo
To: pgsql-performance@postgresql.o= rg=20
Sent: Friday, February 21, 2003 = 3:48=20 PM
Subject: [PERFORM] performance i= ssues=20 for processing more then 150000 records / day.

Hello,
 
We would like to use PostgreSQL for on= e=20 project.
This project would need to handle some= of=20 150000 - 200000 (thousands records) per day.
 
Is there somebody having experience wi= th=20 Postgresql in this kind of environment.
Can anybody advice us regarding specif= ic=20 PostgreSQL issues for such kind of datamanipulation ?
 
Best Regards,
Jaki
------=_NextPart_000_0079_01C2D994.B49FE480--