[HACKERS] Comparing Datum's at aminsert() stage

l_tuple(), is it OK to use index_getattr()? And how do I compare 2 Datums? I need FmgrInfo pointer for the equality operator of the corresponding data type. Are there any API calls to obtain one? Thank you. -- Victor Y. Yegorov ---(end of broadcast)---

Re: [HACKERS] Comparing Datum's at aminsert() stage

um is a good idea, but it's need to be unique. Is it possible with any existing API? -- Victor Y. Yegorov ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[HACKERS] Best way to scan on-disk bitmaps

IDs at given position in the map later)? This will, probably, require more functions in the pg_am catalog. Or should I create a completely new node for on-disk bitmaps? -- Victor Y. Yegorov ---(end of broadcast)--- TIP 2: you can get off all lis

Re: [HACKERS] Best way to scan on-disk bitmaps

er pick an index scan for WHERE a = 42 AND b = 'foo' (i.e. only part of the index attributes are involved)? Any modifications needed to achieve this functionality? To my mind, bitmap scan even for 1 attribute of a multi-column index would be a win, though I haven't t

[HACKERS] adding new pages bulky way

uestion is: allocating pages this way is really ugly, I understand. Is there some API that would allow allocating N pages in the bulk way? Maybe this is a know problem, that has been already solved before? Any other ideas? Thanks in advance! -- Victor Y. Yegorov ---(end of b

Re: [HACKERS] adding new pages bulky way

myself. Is it so? BTW, are there any differences in buffer seeking speed, if buffer block-numbers are mixed and if they're not (i.e. P_NEW is used)? -- Victor Y. Yegorov ---(end of broadcast)--- TIP 9: the planner will ignore your desire t

Re: [HACKERS] adding new pages bulky way

ber; 2) then I do LockRelationForExtension; ReadBuffer(135) and UnockRelationForExtension. What BlockNumber will be assigned to the buffer, if I call ReadBuffer(P_NEW) now? 136? BTW, is it OK to say "BlockNumber is assigned to buffer"? -- Victor Y. Yegorov -

[HACKERS] make distclean keeps some files

ibpq/blibpqdll.def src/interfaces/libpq/libpqddll.def src/interfaces/libpq/libpqdll.def src/interfaces/libpq/libpq.rc src/pl/plpgsql/src/pl_gram.c src/pl/plpgsql/src/pl_scan.c src/pl/plpgsql/src/pl.tab.h Are they kept intentionally? -- Victor Y. Yegorov --

Re: [HACKERS] Schedule for 8.1 feature freeze

I'll do my best to submit bitmap index AM patch next week for your review. -- Victor Y. Yegorov ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] Implementing Bitmap Indexes

Hello. I'd like to implement bitmap indexes and want your comments. Here is an essence of what I've found regarding bitmaps for the last month. Consider the following table So, the bitmap for attribute A will be the with 1 attribute A(int2): following: # | A Val | Bi

Re: [HACKERS] Implementing Bitmap Indexes

* Tom Lane <[EMAIL PROTECTED]> [29.01.2005 18:24]: > "Victor Y. Yegorov" <[EMAIL PROTECTED]> writes: > > I remember, Tom Lane suggested on-disk bitmaps > > I have suggested no such thing, and in fact believe that the sort of > index structure you are propos

Re: [HACKERS] Implementing Bitmap Indexes

it as a team? Yes, why not. But everything depends on the community, may bitmaps will be realized as a contrib or pgfoundry module. The only thing --- I don't know, if that is possible for indexes. -- Victor Y. Yegorov ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] bitmap AM design

cism on this design. I've started to implement AM, I need to register am* functions, what OIDs should use to register them in include/catalog/pg_proc.h? Waiting for your feedback. -- Victor Y. Yegorov ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] bitmap AM design

e speaking about? On-disk bitmaps (this is how I call new index access method I'm working on) or in-memory bitmaps, as in here http://archives.postgresql.org/pgsql-hackers/2005-01/msg01001.php Thanks for your reply. -- Victor Y. Yegorov ---(end of broadcast)--

Re: [HACKERS] bitmap AM design

ly attributes' related data and pointers to start page of corresponding bitmap, there won't be many pages in this list. Maybe, there are some more insufficiencies I've missed? -- Victor Y. Yegorov ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] bitmap AM design

erequisites would be required to join both bitmaps somehow? Waiting for your thoughts/comments. -- Victor Y. Yegorov ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster