Re: [HACKERS] Re: Browsing the tables and why pgsql does not perform well
| От | Brett McCormick |
|---|---|
| Тема | Re: [HACKERS] Re: Browsing the tables and why pgsql does not perform well |
| Дата | |
| Msg-id | 199801242302.PAA25187@abraxas.scene.com обсуждение |
| Ответ на | Re: Browsing the tables and why pgsql does not perform well (Hannu Krosing <hannu@trust.ee>) |
| Ответы |
Re: [HACKERS] Re: Browsing the tables and why pgsql does not perform well
|
| Список | 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� > > > >
В списке pgsql-hackers по дате отправления: