pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Turner <armtuk@gmail.com>
To: bsimon@loxane.com <bsimon@loxane.com>
Cc: pgsql-performance@postgresql.org, "Mohan, Ross" <RMohan@arbinet.com>
Subject: Re: RE : RE: Postgresql vs SQLserver for this application ?
Date: Wed, 6 Apr 2005 11:37:30 -0400
Message-ID: <33c6269f05040608377dfc9272@mail.gmail.com> (raw)
In-Reply-To: <OF9F44D17F.4458ADD0-ONC1256FDB.0027AF25-C1256FDB.002792BB@beauchamp.loxane.fr>
References: <OF9F44D17F.4458ADD0-ONC1256FDB.0027AF25-C1256FDB.002792BB@beauchamp.loxane.fr>

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 <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" <RMohan@arbinet.com> 
> 
> 05/04/2005 20:48 
>          
>         Pour :        <bsimon@loxane.com> 
>         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. 
>  
>  
>



view thread (5+ messages)  latest in thread

Message-ID: <33c6269f05040608377dfc9272@mail.gmail.com>
Permalink:  ../33c6269f05040608377dfc9272@mail.gmail.com/
Also on:    postgresql.org/message-id/33c6269f05040608377dfc9272@mail.gmail.com

 · 

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: armtuk@gmail.com, bsimon@loxane.com, RMohan@arbinet.com
  Subject: Re: RE : RE: Postgresql vs SQLserver for this application ?
  In-Reply-To: <33c6269f05040608377dfc9272@mail.gmail.com>

* 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