Thread: ambulkdelete

ambulkdelete

From
David Hoksza
Date:
Hi, I would like to know, when ambulkdelete is run. I thought that
when tuple is deleted so bulkdelete is run, but when I set breakpoint
to btbulkdelete, it doesn't stop there. Does it mean, that
ambulkdelete is run just when I use VACUUM?

David Hoksza


Re: ambulkdelete

From
"Jim C. Nasby"
Date:
On Sun, Mar 26, 2006 at 08:30:44PM +0200, David Hoksza wrote:
> Hi, I would like to know, when ambulkdelete is run. I thought that
> when tuple is deleted so bulkdelete is run, but when I set breakpoint
> to btbulkdelete, it doesn't stop there. Does it mean, that
> ambulkdelete is run just when I use VACUUM?

BTW, -hackers is a better place for this...

decibel@phonebook.1[6:50]~/pgsql/HEAD/src/backend:5%grep -ri ambulkdelete *
access/index/indexam.c: GET_REL_PROCEDURE(ambulkdelete);
commands/vacuum.c:       * ambulkdelete call, because (a) the scan happens within the index AM for
commands/vacuumlazy.c:   * ambulkdelete call, because (a) the scan happens within the index AM for
decibel@phonebook.1[6:50]~/pgsql/HEAD/src/backend:6%grep -ri btbulkdelete *
access/nbtree/nbtree.c:btbulkdelete(PG_FUNCTION_ARGS)
access/nbtree/nbtree.c:          * concurrent btbulkdelete scan cannot pass our position --- if it
access/nbtree/README:(see btbulkdelete).
decibel@phonebook.1[6:50]~/pgsql/HEAD/src/backend:7%
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Re: ambulkdelete

From
Simon Riggs
Date:
On Sun, 2006-03-26 at 20:30 +0200, David Hoksza wrote:
> Hi, I would like to know, when ambulkdelete is run. I thought that
> when tuple is deleted so bulkdelete is run, but when I set breakpoint
> to btbulkdelete, it doesn't stop there.

> Does it mean, that
> ambulkdelete is run just when I use VACUUM?

Yes

Best Regards, Simon Riggs


Re: ambulkdelete

From
David Hoksza
Date:
OK, thx...

________________________________
27. března 2006, 14:51:26, napsal jste:

JCN> On Sun, Mar 26, 2006 at 08:30:44PM +0200, David Hoksza wrote:
>> Hi, I would like to know, when ambulkdelete is run. I thought that
>> when tuple is deleted so bulkdelete is run, but when I set breakpoint
>> to btbulkdelete, it doesn't stop there. Does it mean, that
>> ambulkdelete is run just when I use VACUUM?

JCN> BTW, -hackers is a better place for this...

JCN> decibel@phonebook.1[6:50]~/pgsql/HEAD/src/backend:5%grep -ri ambulkdelete *
JCN> access/index/indexam.c: GET_REL_PROCEDURE(ambulkdelete);
JCN> commands/vacuum.c:       * ambulkdelete call, because (a) the
JCN> scan happens within the index AM for
JCN> commands/vacuumlazy.c:   * ambulkdelete call, because (a) the
JCN> scan happens within the index AM for
JCN> decibel@phonebook.1[6:50]~/pgsql/HEAD/src/backend:6%grep -ri btbulkdelete *
JCN> access/nbtree/nbtree.c:btbulkdelete(PG_FUNCTION_ARGS)
JCN> access/nbtree/nbtree.c:          * concurrent btbulkdelete scan
JCN> cannot pass our position --- if it
JCN> access/nbtree/README:(see btbulkdelete).
JCN> decibel@phonebook.1[6:50]~/pgsql/HEAD/src/backend:7%