From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jim C. Nasby <jim@nasby.net>
Cc: ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Dead Space Map version 2
Date: Wed, 28 Feb 2007 09:51:46 +0000
Message-ID: <45E550B2.8030104@enterprisedb.com> (raw)
In-Reply-To: <25502.1172640891@sss.pgh.pa.us>
References: <20070227113655.6381.ITAGAKI.TAKAHIRO@oss.ntt.co.jp>
<20070227051144.GK29041@nasby.net>
<12631.1172555721@sss.pgh.pa.us>
<45E3FF0D.2050104@enterprisedb.com>
<25502.1172640891@sss.pgh.pa.us>
Tom Lane wrote:
> Heikki Linnakangas <heikki@enterprisedb.com> writes:
>> Tom Lane wrote:
>>> I'd be happier if the DSM content could be
>>> treated as just a hint.
>
>> If we don't have a frozen state, we can't use the DSM to implement
>> index-only scans.
>
> To implement index-only scans, the DSM would have to be expected to
> provide 100% reliable coverage, which will increase its cost and
> complexity by orders of magnitude. If you insist on that, I will bet
> you lunch at a fine restaurant that it doesn't make it into 8.3.
:)
While I understand that 100% reliable coverage is a significantly
stronger guarantee, I don't see any particular problems in implementing
that. WAL logging isn't that hard.
I won't insist, I'm not the one doing the programming after all.
Anything is better than what we have now. However, I do hope that
whatever is implemented doesn't need a complete rewrite to make it 100%
reliable in the future.
The basic wish I have is to not use a fixed size shared memory area like
FSM for the DSM. I'd like it to use the shared buffers instead, which
makes the memory management and tuning easier. And it also makes it
easier to get the WAL logging right, even if it's not done for 8.3 but
added later.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
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: heikki@enterprisedb.com, tgl@sss.pgh.pa.us, jim@nasby.net, itagaki.takahiro@oss.ntt.co.jp, pgsql-hackers@postgresql.org
Subject: Re: Dead Space Map version 2
In-Reply-To: <45E550B2.8030104@enterprisedb.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