Re: [HACKERS] kill_prior_tuple for bitmap scan

2006-06-18 Thread Qingqing Zhou
"Tom Lane" <[EMAIL PROTECTED]> wrote > > Really? An indexscan will release pin before returning no-more-tuples, > and had better do so else we leak pins during queries involving many > indexscans. > I guess I see your point. For the scan stages not returning no-more-tuples, we can do kill, but t

Re: [HACKERS] kill_prior_tuple for bitmap scan

2006-06-18 Thread Tom Lane
"Qingqing Zhou" <[EMAIL PROTECTED]> writes: > As I read, the kill_prior_tuple optimization doesn't work for bitmap scan > code. To fix this problem, we have two choices. > One is still use the kill_prior_tuple trick in a modified way. Heap TIDs > recycling should not be a problem. This is because

[HACKERS] kill_prior_tuple for bitmap scan

2006-06-18 Thread Qingqing Zhou
As I read, the kill_prior_tuple optimization doesn't work for bitmap scan code. To fix this problem, we have two choices. One is still use the kill_prior_tuple trick in a modified way. Heap TIDs recycling should not be a problem. This is because generally we always hold pin of the last index page