Re: [HACKERS] Re: Browsing the tables and why pgsql does not perform well

From: Brett McCormick <brett(at)abraxas(dot)scene(dot)com>
To: Hannu Krosing <hannu(at)trust(dot)ee>
Cc: scrappy(at)hub(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: Browsing the tables and why pgsql does not perform well
Date: 1998-01-24 23:02:09
Message-ID: 199801242302.PAA25187@abraxas.scene.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, 24 January 1998, at 09:36:41, Hannu Krosing wrote:

> The main problem is that PostgreSQL does not use index for sorting and
> thus really does a
> "copy" of the whole table and then sorts it before it can use a few rows
> from the beginning.
>
> Using indexes for sorting as well as selecting is on the TODO list, but
> seems to be not very high priority.

It doesn't seem like it would be very difficult -- I'd be happy to
tackle it if given some pointers in the right direction (I am a newbie
pgsql-hacker and I'm looking for work! give me some!!)

--brett

> OTOOH, it would be very hard for general client side tools to do without
> keyed access, so addind using indexes for sorting should be given at
> least some priority.
>
> ----------------
> Hannu Krosing
> Trust-O-Matic O
>
> >
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rick Poleshuck 1998-01-24 23:08:55 Revoke update on Column
Previous Message Tom 1998-01-24 22:53:22 Re: [HACKERS] fork/exec for backend