pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gary Doades <gpd@gpdnet.co.uk>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and Linux 2.6 kernel.
Date: Sun, 04 Apr 2004 10:00:10 +0100
Message-ID: <406FDCAA.30459.24B450F@localhost> (raw)
In-Reply-To: <Law10-OE20fCAUEZKgM000043af@hotmail.com>

Unfortunately I have to try and keep both SQLServer and PostgreSQL 
compatibilty. Our main web application is currently SQLServer, but we 
want to migrate customers who don't care what the DB server is over to 
PostgreSQL. Some of our larger customers demand SQLServer, you 
know how it is!

I don't want to maintain two sets of code or SQL, so I am trying to find 
common ground. The code is not a problem, but the SQL sometimes is.

Cheers,
Gary.


On 3 Apr 2004 at 17:43, Aaron Werman wrote:

> Almost any cross dbms migration shows a drop in performance. The engine
> effectively trains developers and administrators in what works and what
> doesn't. The initial migration thus compares a tuned to an untuned version.
> 
> /Aaron
> 
> ----- Original Message ----- 
> From: "Josh Berkus" <josh@agliodbs.com>
> To: "Gary Doades" <gpd@gpdnet.co.uk>; <pgsql-performance@postgresql.org>
> Sent: Saturday, April 03, 2004 1:59 PM
> Subject: Re: [PERFORM] PostgreSQL and Linux 2.6 kernel.
> 
> 
> > Gary,
> >
> > > There are no indexes on the columns involved in the update, they are
> > > not required for my usual select statements. This is an attempt to
> > > slightly denormalise the design to get the performance up comparable
> > > to SQL Server 2000. We hope to move some of our databases over to
> > > PostgreSQL later in the year and this is part of the ongoing testing.
> > > SQLServer's query optimiser is a bit smarter that PostgreSQL's (yet)
> > > so I am hand optimising some of the more frequently used
> > > SQL and/or tweaking the database design slightly.
> >
> > Hmmm ... that hasn't been my general experience on complex queries.
> However,
> > it may be due to a difference in ANALYZE statistics.   I'd love to see you
> > increase your default_stats_target, re-analyze, and see if PostgreSQL gets
> > "smarter".
> >
> > -- 
> > -Josh Berkus
> >  Aglio Database Solutions
> >  San Francisco
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> >       subscribe-nomail command to majordomo@postgresql.org so that your
> >       message can get through to the mailing list cleanly
> >
> 
> 
> -- 
> Incoming mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.230 / Virus Database: 262.6.5 - Release Date: 31/03/2004
> 





view thread (34+ messages)  latest in thread

Message-ID: <406FDCAA.30459.24B450F@localhost>
Permalink:  ../406FDCAA.30459.24B450F@localhost/
Also on:    postgresql.org/message-id/406FDCAA.30459.24B450F@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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gpd@gpdnet.co.uk
  Subject: Re: PostgreSQL and Linux 2.6 kernel.
  In-Reply-To: <406FDCAA.30459.24B450F@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