Koichi Suzuki escribió:
> Does anyone know how to generate the following WAL records from psql?
> I'm now fixing pg_lesslog, which I reported a bug. Now code is
> almost okay and I'd like to add test tools to show pg_lesslog can
> handle all the WAL record correctly.
For these, you need to do SELECT FOR SHARE of a tuple in more than one
I think HEAP_LOCK is SELECT FOR UPDATE.
These are caused during vacuum of a btree. Create an index, populate
it, then remove all items. Then vacuum twice.
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2010-04-14 00:01:10|
|Subject: Re: Autonomous transaction|
|Previous:||From: Scott Marlowe||Date: 2010-04-13 20:53:03|
|Subject: Re: psql's \d display of unique index vs. constraint|