Re: [HACKERS] Scan Keys

2006-07-07 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: But on that note, is it ok to use the bulkdelete index AM methods for non-vacuum purposes Um, what would those be? I'm sure with a little work I can imagine lots of reasons to want to pull out all the index tuples

Re: [HACKERS] Scan Keys

2006-07-06 Thread Martijn van Oosterhout
On Wed, Jul 05, 2006 at 09:14:21PM -0400, Greg Stark wrote: Well what was tripping me up was figuring out the operator class. I just realized it's in the index's Relation object. But yes what you describe is really a problem. Even given the operator class there's no way for me to know which

Re: [HACKERS] Scan Keys

2006-07-06 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: I'm a bit confused about how scan keys work. Is there any simple way given a list of Datums of the same type as the index tuple attributes to get all matching index entries? This is for a non-system index. Define matching. I tried just using

Re: [HACKERS] Scan Keys

2006-07-06 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: I tried just using index_getprocinfo(...,BTORDER) with InvalidStrategy like btree does but _bt_preprocess_keys runs into problems without a valid strategy number. And in any case that would be btree specific which seems like it ought not be

Re: [HACKERS] Scan Keys

2006-07-06 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: But on that note, is it ok to use the bulkdelete index AM methods for non-vacuum purposes Um, what would those be? ambulkdelete and amvacuumcleanup are most certainly not designed to be used in any context other than VACUUM. You might be able to abuse them

[HACKERS] Scan Keys

2006-07-05 Thread Greg Stark
I'm a bit confused about how scan keys work. Is there any simple way given a list of Datums of the same type as the index tuple attributes to get all matching index entries? This is for a non-system index. It seems like the only place in the code where non-system index lookups are done is

Re: [HACKERS] Scan Keys

2006-07-05 Thread Martijn van Oosterhout
On Wed, Jul 05, 2006 at 12:00:05PM -0400, Greg Stark wrote: I'm a bit confused about how scan keys work. Is there any simple way given a list of Datums of the same type as the index tuple attributes to get all matching index entries? This is for a non-system index. A scankey determines which

Re: [HACKERS] Scan Keys

2006-07-05 Thread Greg Stark
Martijn van Oosterhout kleptog@svana.org writes: The info you need is in the operator class. In a sense you do need to know the type of index you're scanning, not all indexes use the same strategy numbers. Well what was tripping me up was figuring out the operator class. I just realized it's