From: Peter Schuller <peter.schuller@infidyne.com>
To: PFC <lists@peufeu.com>
Cc: Andreas Kostyrka <andreas@kostyrka.org>
Cc: Arjen van der Meijden <acmmailing@tweakers.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Benchmark Results
Date: Tue, 22 May 2007 08:28:57 +0200
Message-ID: <46528DA9.1000406@infidyne.com> (raw)
In-Reply-To: <op.tso4w0p3cigqcu@apollo13>
References: <bfzdbQBLKRHL.1C30nvw2@heaven.kostyrka.org>
<op.tso4w0p3cigqcu@apollo13>
> - Deferred Transactions, since adding a comment to a blog post
> doesn't need the same guarantees than submitting a paid order, it makes
> sense that the application could tell postgres which transactions we
> care about if power is lost. This will massively boost performance for
> websites I believe.
This would be massively useful. Very often all I care about is that the
transaction is semantically committed; that is, that other transactions
starting from that moment will see the modifications done. As opposed to
actually persisting data to disk.
In particular I have a situation where I attempt to utilize available
hardware by using concurrency. The problem is that I have to either
hugely complicate my client code or COMMIT more often than I would like
in order to satisfy dependencies between different transactions. If a
deferred/delayed commit were possible I could get all the performance
benefit without the code complexity, and with no penalty (because in
this case persistence is not important).
--
/ Peter Schuller
PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.orgAttachments:
signature.asc (application/pgp-signature, 249B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: peter.schuller@infidyne.com, lists@peufeu.com, andreas@kostyrka.org, acmmailing@tweakers.net
Subject: Re: Postgres Benchmark Results
In-Reply-To: <46528DA9.1000406@infidyne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox