Re: unlogged tables
Andy Colson <andy@squeakycode.net>
From: Andy Colson <andy@squeakycode.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2010-11-16T18:09:47Z
Lists: pgsql-hackers
I was able to apply and compile and run ok, creating unlogged tables seems to work as well. I patched up pgbench to optionally create unlogged tables, and ran it both ways. I get ~80tps normally, and ~1,500tps with unlogged. (Thats from memory, was playing with it last night at home) I also have a "real world" test I can try (import apache logs and run a few stats). What other things would be good to test: indexes? analyze/stats/plans? dump/restore? Is "create temp unlogged table stuff(...)" an option? -Andy