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: Mon, 05 Apr 2004 19:11:56 +0100
Message-ID: <4071AF7C.15265.52B583C@localhost> (raw)
In-Reply-To: <200404050836.52115.josh@agliodbs.com>
References: <200404040323.i343Nw3Z002747@gw.tssi.com>

On 5 Apr 2004 at 8:36, Josh Berkus wrote:

> 
> Point taken, though, SQL Server has done a better job in opitimizing for 
> "dumb" queries.   This is something that PostgreSQL needs to work on, as is 
> self-referential updates for large tables, which also tend to be really slow.   
> Mind you, in SQL Server 7 I used to be able to crash the server with a big 
> self-referential update, so this is a common database problem.
> 

I agree about the "dumb" queries (I'm not mine are *that* dumb :) )

When you can write SQL that looks right, feels right, gives the right 
answers during testing and SQLServer runs them really fast, you stop 
there and tend not to tinker with the SQL further.

You *can* (I certainly do) achieve comparable performance with 
PostgreSQL, but you just have to work harder for it. Now that I have 
learned the characteristics of both servers I can write SQL that is pretty 
good on both. I suspect that there are people who evaluate PostgreSQL 
by executing their favorite SQLSever queries against it, see that it is 
slower and never bother to go further.

Cheers,
Gary.




view thread (34+ messages)  latest in thread

Message-ID: <4071AF7C.15265.52B583C@localhost>
Permalink:  ../4071AF7C.15265.52B583C@localhost/
Also on:    postgresql.org/message-id/4071AF7C.15265.52B583C@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: <4071AF7C.15265.52B583C@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