Skip site navigation (1) Skip section navigation (2)

Re: planner/optimizer question

From: "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: planner/optimizer question
Date: 2004-04-29 23:01:10
Message-ID: 40919746.25550.1555A9CC@localhost (view raw or flat)
Thread:
Lists: pgsql-performance
> 
> Having picked out an index scan as being the highest time user I 
> concentrated on that in  this case and compared the same index scan on 
> MSSQL. At least MSSQL reported it as  an index scan on the same index 
> for the same number of rows. 
> 

I should have also pointed out that MSSQL reported that same index scan as taking 65% of the overall query time.
It was just "faster". The overall query took 103ms in MSSQL.

Gary.


Responses

pgsql-performance by date

Next:From: Joseph ShraibmanDate: 2004-04-29 23:08:23
Subject: Insert only tables and vacuum performance
Previous:From: Gary DoadesDate: 2004-04-29 22:31:00
Subject: Re: planner/optimizer question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group