An Index Scanning Solution question

From: "Atesz" <atesz(at)ritek(dot)hu>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: An Index Scanning Solution question
Date: 2004-05-19 13:17:01
Message-ID: 006c01c43da3$957a4b80$0b02010a@atesz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all!

Earlier I sent a question about multi-order index scanning
(http://archives.postgresql.org/pgsql-sql/2004-04/msg00276.php).
I can solve the problem with own OPERATOR CLASSes. But this solution
increase number of my indexes exponentially. In my applicaton I have
already more then 200 indexes on a table with 500 000 rows. I will have
1 000 000 records at the end of this year.
I'd like to ask why the index scaning can't move on an index in
multi-order directions (For exapmle: 1.column: forward, 2.column:
backward and 3.column: forward again)? So I wouldn't have to use so many
indexes. Has somebody tried to implement this idea in Postgres or is
there a more difficult reason in the postgres implementation which
cause this defect?

Thank you in anticipation!
Antal Attila

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Browne 2004-05-19 14:08:50 AIX Compilation Fun with 7.5 CVS
Previous Message Fabien COELHO 2004-05-19 12:14:12 Re: add server include files to default installation?