Thank you for a great advice. I successfully generated all the WAL
records listed below. By deleteing and VACUUMing a table with
btree_gist based index, I was successful to generate all the GIST WAL
Still have the following WAL record to create:
I have to run good amount of transactions before VACUUM FREEZE to
create CLOG_TRUNCATE. I'll try.
It's very helpful if anybody knows how to generate XLOG_HEAP_INIT_PAGE
I'll ask Oleg-san how to generate GIN-related WALs.
Thank you very much;
2010/4/14 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> 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
> concurrent session.
> 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: Josh Kupershmidt||Date: 2010-04-14 02:19:11|
|Subject: Re: psql's \d display of unique index vs. constraint|
|Previous:||From: Erik Rijkers||Date: 2010-04-14 00:51:42|
|Subject: Re: testing HS/SR - invalid magic number|