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:29:44 +0100
Message-ID: <4092A928.27720.19838422@localhost> (raw)
In-Reply-To: <69EF9EF2-9AA2-11D8-A4E1-000D9366F0C4@torgo.978.org>
References: <409207D6.17204.170D5A52@localhost>

On 30 Apr 2004 at 8:32, Jeff wrote:
> 
>   A better comparision query may be a simple "select a from mytable 
> where a between foo and bar"  to get an index scan.  In that case its a 
> straight up, vanilla index scan.  Nothing else getting in the way.
> 

Yes, you're right and I have done this just to prove to myself that it is the index scan that 
is the bottleneck. I have some complex SQL that executes very quickly with Postgres, 
similar to MSSQL, but the index scans in most of those only touch a few rows for a few 
loops. It seems to be a problem when the index scan is scanning very many rows and 
for each of these it has to go to the table just to find out if the index it just looked at is 
still valid.

Gary.




view thread (37+ messages)  latest in thread

Message-ID: <4092A928.27720.19838422@localhost>
Permalink:  ../4092A928.27720.19838422@localhost/
Also on:    postgresql.org/message-id/4092A928.27720.19838422@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: <4092A928.27720.19838422@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