X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EC881534CC for ; Wed, 6 Apr 2005 16:38:36 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98303-03 for ; Wed, 6 Apr 2005 15:38:30 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by svr1.postgresql.org (Postfix) with ESMTP id 4FC5552A45 for ; Wed, 6 Apr 2005 16:38:29 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so278628wri for ; Wed, 06 Apr 2005 08:38:29 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=eEkzjvOA4xwrP2B8Dimh4zMwOSKiPahh2TP07BJJRm2Xo11gKSpSAl1zWI/PaesOJkyK+JVOxJ7fEPcTBl/IeS2nOkKaLblsOaxtt80tIeQADElHVqTfV+tdPhedC211YvGvi5G2XufszeYA6NuExpkkp99Z5Jy9Bc56asK7MVo= Received: by 10.54.33.47 with SMTP id g47mr35936wrg; Wed, 06 Apr 2005 08:37:30 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Wed, 6 Apr 2005 08:37:30 -0700 (PDT) Message-ID: <33c6269f05040608377dfc9272@mail.gmail.com> Date: Wed, 6 Apr 2005 11:37:30 -0400 From: Alex Turner Reply-To: Alex Turner To: "bsimon@loxane.com" Subject: Re: RE : RE: Postgresql vs SQLserver for this application ? Cc: pgsql-performance@postgresql.org, "Mohan, Ross" In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.485 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200504/98 X-Sequence-Number: 11495 I think everyone was scared off by the 5000 inserts per second number. I've never seen even Oracle do this on a top end Dell system with copious SCSI attached storage. Alex Turner netEconomist On Apr 6, 2005 3:17 AM, bsimon@loxane.com wrote: > > Unfortunately. > > But we are in the the process to choose Postgresql with pgcluster. I'm > currently running some tests (performance, stability...) > Save the money on the license fees, you get it for your hardware ;-) > > I still welcome any advices or comments and I'll let you know how the > project is going on. > > Benjamin. > > > > "Mohan, Ross" > > 05/04/2005 20:48 > > Pour : > cc : > Objet : RE: [PERFORM] Postgresql vs SQLserver for this > application ? > > > You never got answers on this? Apologies, I don't have one, but'd be curious > to hear about any you did get.... > > thx > > Ross > > -----Original Message----- > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org] On Behalf > Of bsimon@loxane.com > Sent: Monday, April 04, 2005 4:02 AM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] Postgresql vs SQLserver for this application ? > > > hi all. > > We are designing a quite big application that requires a high-performance > database backend. > The rates we need to obtain are at least 5000 inserts per second and 15 > selects per second for one connection. There should only be 3 or 4 > simultaneous connections. > I think our main concern is to deal with the constant flow of data coming > from the inserts that must be available for selection as fast as possible. > (kind of real time access ...) > > As a consequence, the database should rapidly increase up to more than one > hundred gigs. We still have to determine how and when we shoud backup old > data to prevent the application from a performance drop. We intend to > develop some kind of real-time partionning on our main table keep the flows > up. > > At first, we were planning to use SQL Server as it has features that in my > opinion could help us a lot : > - replication > - clustering > > Recently we started to study Postgresql as a solution for our project : > - it also has replication > - Postgis module can handle geographic datatypes (which would > facilitate our developments) > - We do have a strong knowledge on Postgresql administration (we use > it for production processes) > - it is free (!) and we could save money for hardware purchase. > > Is SQL server clustering a real asset ? How reliable are Postgresql > replication tools ? Should I trust Postgresql performance for this kind of > needs ? > > My question is a bit fuzzy but any advices are most welcome... > hardware,tuning or design tips as well :)) > > Thanks a lot. > > Benjamin. > > >