From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: unlogged tables |
Date: | 2010-11-16 18:34:55 |
Message-ID: | AANLkTimjK31Fd1g3QGXMd31k=S4Q8h6zv+ApNY=2N0Sg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Nov 16, 2010 at 1:09 PM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> 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)
What do you get with normal tables but with fsync, full_page_writes,
and synchronous_commits turned off?
What do you get with normal tables but with sychronous_commit (only) off?
Can you detect any performance regression on normal tables with the
patch vs. without the patch?
> I also have a "real world" test I can try (import apache logs and run a few
> stats).
That would be great.
> What other things would be good to test:
> indexes?
> analyze/stats/plans?
> dump/restore?
All of those. I guess there's a question of what pg_dump should emit
for an unlogged table. Clearly, we need to dump a CREATE UNLOGGED
TABLE statement (which we do), and right now we also dump the table
contents - which seems reasonable, but arguably someone could say that
we ought not to dump the contents of anything less than a
full-fledged, permanent table.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-11-16 18:36:16 | Re: Extensible executor nodes for preparation of SQL/MED |
Previous Message | Tom Lane | 2010-11-16 18:28:50 | Re: Extensible executor nodes for preparation of SQL/MED |