Re: unlogged tables - Mailing list pgsql-hackers

From Andy Colson
Subject Re: unlogged tables
Date
Msg-id 4CE2C8EB.20807@squeakycode.net
Whole thread Raw
In response to Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: unlogged tables
Re: unlogged tables
List 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


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: GCC vs clang
Next
From: Tom Lane
Date:
Subject: Re: GCC vs clang