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

Re: Serious performance problem

From: "Tille, Andreas" <TilleA(at)rki(dot)de>
To:
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Serious performance problem
Date: 2001-10-30 09:59:10
Message-ID: Pine.LNX.4.33.0110301056320.6117-100000@wr-linux02.rki.ivbb.bund.de (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 29 Oct 2001, Vsevolod Lobko wrote:

> Seems that problem is very simple :))
> MSSql can do queries from indexes, without using actual table at all.
> Postgresql doesn't.
>
> So mssql avoids sequental scanning of big table, and simply does scan of
> index which is already in needed order and has very much less size.
Hmmm, could anyone imagine a simple or not *solution* of the Problem.
I´m thinking of some switch the database programmer could use if he
really knows what he is doing.

Kind regards

        Andreas.

In response to

pgsql-hackers by date

Next:From: Dave PageDate: 2001-10-30 10:02:00
Subject: Re: DROP/CREATE
Previous:From: Tille, AndreasDate: 2001-10-30 09:55:50
Subject: Re: Serious performance problem

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