[HACKERS] How to generate specific WAL records again for PostgreSQL 9.0?

2010-06-07 Thread Koichi Suzuki
Hi, I've ported pg_lesslog to PostgreSQL 9.0 and I'm testing it. I'm not successful to produce the following WAL records. XLOG_HEAP_INIT_PAGE XLOG_BTREE_REUSE_PAGE XLOG_GIST_PAGE_DELETE XLOG_RELMAP_UPDATE Any suggestions are welcome. Thank you very much; -- Koichi Suzuki -- Sent via

Re: [HACKERS] How to generate specific WAL records?

2010-04-18 Thread Koichi Suzuki
Now I've tested almost all WAL record, including CLOG_TRUNCATE and all the GIST and GIN-related WALs. I'm still struggling to find how to have XLOG_HEAP_INIT_PAGE and XLOG_BTREE_INSERT_META. I'm trying to find how to have these WAL records but it's a great help if anyone suggests me how. Thank

Re: [HACKERS] How to generate specific WAL records?

2010-04-14 Thread Bruce Momjian
Kevin Grittner wrote: > Koichi Suzuki wrote: > > 2010/4/14 Simon Riggs : > > >> It would be a very useful test case to publish. > > > I'm still struggling to generate remaing WAL records. > > Sure, but when you've got it all, please share. I'd like to see us > have a much larger set of test

Re: [HACKERS] How to generate specific WAL records?

2010-04-14 Thread Kevin Grittner
Koichi Suzuki wrote: > 2010/4/14 Simon Riggs : >> It would be a very useful test case to publish. > I'm still struggling to generate remaing WAL records. Sure, but when you've got it all, please share. I'd like to see us have a much larger set of tests than the "make check" regression tests

Re: [HACKERS] How to generate specific WAL records?

2010-04-14 Thread Koichi Suzuki
Thanks for encouraging comment. I'm still struggling to generate remaing WAL records. -- Koichi Suzuki 2010/4/14 Simon Riggs : > On Wed, 2010-04-14 at 11:13 +0900, Koichi Suzuki wrote: > >> Thank you for a great advice.   I successfully generated all the WAL >> records listed below.  

Re: [HACKERS] How to generate specific WAL records?

2010-04-14 Thread Simon Riggs
On Wed, 2010-04-14 at 11:13 +0900, Koichi Suzuki wrote: > 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 > records. It would be a very us

Re: [HACKERS] How to generate specific WAL records?

2010-04-13 Thread Koichi Suzuki
Alvaro-san; 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 records. Still have the following WAL record to create: CLOG_TRUNCATE XLOG_HEAP_I

Re: [HACKERS] How to generate specific WAL records?

2010-04-13 Thread Alvaro Herrera
Koichi Suzuki escribió: > Hi, > > 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. > > XLOG_MULTIXA

[HACKERS] How to generate specific WAL records?

2010-04-13 Thread Koichi Suzuki
Hi, 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. XLOG_MULTIXACT_ZERO_OFF_PAGE XLOG_MULTIXACT_ZERO_MEM_P