New accec method

Started by Thiago Venturaalmost 19 years ago2 messagesgeneral
Jump to latest
#1Thiago Ventura
thiventura@gmail.com

Hi,
I am trying create a new access method for the PostgreSQL.
Reading the manual, I learned that must implement 12 functions (build,
insert, gettuple, beginscan, ...).
In the begin its OK. As soon as I type the command 'CREATE INDEX' the
function 'build' is call and the index is create. When I call the command
'INSERT' all its OK too.
The problem is when I do some query. NEVER its call the 'beginscan',
'gettuple' or another function that is related with a query, that is, in the
querys my index do not being used.
What it can be causing this?

Since already I am thankful,
Thiago M. Ventura

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thiago Ventura (#1)
Re: New accec method

"Thiago Ventura" <thiventura@gmail.com> writes:

The problem is when I do some query. NEVER its call the 'beginscan',
'gettuple' or another function that is related with a query, that is, in the
querys my index do not being used.
What it can be causing this?

Have you created operator classes to show what WHERE-clauses can be used
with the index?

regards, tom lane