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: planner/optimizer question
Date: Fri, 30 Apr 2004 19:59:38 +0100
Message-ID: <4092B02A.15469.199EE3DE@localhost> (raw)
In-Reply-To: <409264C4.8060506@speedfc.com>
References: <40920137.13806.16F37CC5@localhost>

On 30 Apr 2004 at 9:37, Kevin Barnard wrote:

> 
> I was always under the impression that MSSQL used leaf and row level locking and therefore 
> was not a concurrent, in the same sense that postgres is, database. It would still allow for 
> concurrent connections and such but updates will get blocked/ delayed. I might be wrong.
> 

Ultimately you may be right. I don't know enough about SQLServer 
internals to say either way. Anyway, most of our system is in selects for 
70% of the time. I could try and set up a test for this when I get a bit 
more time.

Unfortunately I suspect that this topic won't get taken much further. In 
order to test this it would mean modifying quite a bit of code. Whether 
putting additional info in the index header and not visiting the data row 
if all the required data is in the index would be beneficial would require 
quite a bit of work by someone who knows more than I do. I reckon that 
no-one has the time to do this at the moment.

Regards,
Gary.




view thread (37+ messages)  latest in thread

Message-ID: <4092B02A.15469.199EE3DE@localhost>
Permalink:  ../4092B02A.15469.199EE3DE@localhost/
Also on:    postgresql.org/message-id/4092B02A.15469.199EE3DE@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: planner/optimizer question
  In-Reply-To: <4092B02A.15469.199EE3DE@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