This needs additional changes for memory mangement and we don't have
time to do that for 8.3, Sorry:
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---
ITAGAKI
Gregory Stark wrote:
Hiroki Kataoka [EMAIL PROTECTED] writes:
I think there is no problem. Bloating will make pages including the
unnecessary area which will not be accessed. Soon, those pages will be
registered into DSM.
Except the whole point of the DSM is to let us vacuum those pages
Hiroki Kataoka [EMAIL PROTECTED] writes:
I think there is no problem. Bloating will make pages including the
unnecessary area which will not be accessed. Soon, those pages will be
registered into DSM.
Except the whole point of the DSM is to let us vacuum those pages *before*
that happens...
Heikki Linnakangas wrote:
The way you update the DSM is quite interesting. When a page is dirtied,
the BM_DSM_DIRTY flag is set in the buffer descriptor. The corresponding
bit in the DSM is set lazily in FlushBuffer whenever BM_DSM_DIRTY is
set. That's a clever way to avoid contention on
ITAGAKI Takahiro wrote:
Attached is an updated DSM patch. I've left the core function of DSM only
and dropped other complicated features in this release.
We discussed it a long time ago already, but I really wished the DSM
wouldn't need a fixed size shared memory area. It's one more thing the
On 3/30/07, ITAGAKI Takahiro [EMAIL PROTECTED] wrote:
Attached is an updated DSM patch. I've left the core function of DSM only
and dropped other complicated features in this release.
I was testing this patch when got this server crash. The patch is applied
on the current CVS HEAD. I thought
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---
Attached is an updated DSM patch. I've left the core function of DSM only
and dropped other complicated features in this release.
VACUUM finishs faster with the patch, but it's obvious... DSM vacuum
sweeps only pages that have many dead tuples and leave some of them
after vacuum.
I'll examine