Hello, long time no see.
This topic looks interesting. I'm enrious of Itagaki-san and others.
I can't do now what I want, due to other work that I don't want to do
(isn't my boss seeing this?). I wish I could join the community some
day and contribute to the development like the great experts here.
# I can't wait to try Itagakis-san's latest patch for load distributed
checkpoint in my environment and report the result.
# But I may not have enough time...
Let me give some comment below.
From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
> While I understand that 100% reliable coverage is a significantly
> stronger guarantee, I don't see any particular problems in
> 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
> reliable in the future.
> The basic wish I have is to not use a fixed size shared memory area
> FSM for the DSM. I'd like it to use the shared buffers instead,
> 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
> added later.
I hope for the same thing as Heikki-san. Though I'm relatively new to
PostgreSQL source code, I don't think it is very difficult (at least
for experts here) to implement the reliable space management scheme,
so I proposed the following before -- not separate memory area for
FSM, but treating it the same way as data files in the shared buffers.
Though Tom-san is worrying about performance, what makes the
performance degrade greatly? Additional WAL records for updating
space management structures are written sequentially in batch.
Additional dirty shared buffers are written efficiently by kernel (at
least now.) And PostgreSQL is released from the giant lwlock for FSM.
Some performance degradation would surely result. However,
reliability is more important because "vacuum" is almost the greatest
concern for real serious users (not for hobbists who enjoy
performance.) Can anybody say to users "we are working hard, but our
work may not be reliable and sometimes fails. Can you see if our
vacuuming effort failed and try this...?"
And I'm afraid that increasing the number of configuration parameters
is unacceptable for users. It is merely the excuse of developers.
PostgreSQL already has more than 100 parameters. Some of them, such
as bgwriter_*, are difficult for normal users to understand. It's
best to use shared_buffers parameter and show how to set it in the
Addressing the vacuum problem correctly is very important. I hope you
don't introduce new parameters for unfinished work and force users to
check the manual to change the parameters in later versions, i.e.
"managed_* parameters are not supported from this release. Please use
shared_buffers..." Is it a "must" to release 8.3 by this summer? I
think that delaying the release a bit for correct (reliable) vacuum
resolution is worth.
From: "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
> Yes! I'm completely in favor of Itagaki-san. Separating the cache
> FSM may produce a new configuration parameter like fsm_cache_size,
> which the normal users would not desire (unless they like enjoying
> difficult DBMS.)
> I think that integrating the treatment of space management structure
> and data area is good. That means, for example, implementing "Free
> Space Table" described in section 220.127.116.11 of Jim Gray's book
> "Transaction Processing: Concepts and Techniques", though it may
> been discussed in PostgreSQL community far long ago (really?). Of
> course, some refinements may be necessary to tune to PostgreSQL's
> concept, say, creating one free space table file for each data file
> make the implementation easy. It would reduce the source code
> for FSM.
> In addition, it would provide the transactional space management.
> I understand correctly, in the current implementation, updates to
> are lost when the server crashes, aren't they? The idea assumes
> FSM will be rebuilt by vacuum because vacuum is inevitable. If
> updates to space management area were made transactional, it might
> provide the infrastructure for "vacuumless PostgreSQL."
In response to
pgsql-performance by date
|Next:||From: Bruno Wolff III||Date: 2007-03-01 03:28:46|
|Subject: Re: Two hard drives --- what to do with them?|
|Previous:||From: Carlos Moreno||Date: 2007-02-28 21:33:23|
|Subject: Re: Upgraded to 8.2.3 --- still having performance issues|
pgsql-hackers by date
|Next:||From: ITAGAKI Takahiro||Date: 2007-03-01 02:00:36|
|Subject: Re: VACUUM and spoiling the buffer manager cache|
|Previous:||From: Jonah H. Harris||Date: 2007-03-01 00:40:56|
|Subject: Re: COMMIT NOWAIT Performance Option|
pgsql-patches by date
|Next:||From: Patric Bechtel||Date: 2007-03-01 01:37:28|
|Subject: Re: Numeric patch to add special-case representations for
< 8 bytes|
|Previous:||From: Joshua D. Drake||Date: 2007-03-01 00:26:30|
|Subject: Re: [HACKERS] |