Sorry, I had a mistake in the patch I sent.
This is a fixed version.
I wrote:
> I'm working on making the bgwriter to write almost of dirty pages. This is
> the proposal for it using automatic adjustment of bgwriter_lru_maxpages.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
a
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Index: src/backend/access/nbtree/nbtinsert.c
===
RCS file: /home/hlinnaka/pgcvsrepository/pgsql/src/backend/access/nbtree/nbtinsert.c,v
retrieving revision 1.152
di
"Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> > * Aggressive freezing
> > we will use OldestXmin as the threshold to freeze tuples in
> > dirty pages or pages that have some dead tuples. Or, many UNFROZEN
> > pages still remain after vacuum and they will cost us in the next
> > vacuum preventing XID
On Mon, 2007-03-05 at 09:51 +, Heikki Linnakangas wrote:
> /*
> !* Scan over all items to see which ones need to be deleted
> !* according to LP_DELETE flags.
> */
Applied, thanks.
-Neil
---(end of broadcast)---
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
> This is a stand-alone patch for aggressive freezing. I'll propose
> to use OldestXmin instead of FreezeLimit as the freeze threshold
> in the circumstances below:
I think it's a really bad idea to freeze that aggressively under any
circumstances excep
WIP patch for diagnostic/test functions for heap pages. (Linked to
discussion thread on -hackers "HOT - Whats Next?")
Specifically designed to allow test cases to be written that prove that
HOT works, as well as allowing diagnosis of general heap page content
errors.
Patch, plus additional file:
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> WIP patch for diagnostic/test functions for heap pages. (Linked to
> discussion thread on -hackers "HOT - Whats Next?")
--- no security checks; surely these must be superuser-only.
--- relation_open will succeed on things that don't have storage;
better
On Mon, 2007-03-05 at 14:31 -0500, Tom Lane wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > WIP patch for diagnostic/test functions for heap pages. (Linked to
> > discussion thread on -hackers "HOT - Whats Next?")
>
> --- no security checks; surely these must be superuser-only.
OK thanks
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Mon, 2007-03-05 at 14:31 -0500, Tom Lane wrote:
>> Exactly what will these allow that you can't do with inspection of ctid
>> etc? (I suspect your answer will be "can't see infomask", but I'd
>> rather expose that as a new system column than invent fu
Tom Lane wrote:
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
This is a stand-alone patch for aggressive freezing. I'll propose
to use OldestXmin instead of FreezeLimit as the freeze threshold
in the circumstances below:
I think it's a really bad idea to freeze that aggressively under any
circu
Florian G. Pflug wrote:
There could be a GUC vacuum_freeze_limit, and the actual FreezeLimit
would be calculated as
GetOldestXmin() - vacuum_freeze_limit
We already have that. It's called vacuum_freeze_min_age, and the default
is 100 million transactions.
IIRC we added it late in the 8.2 re
Heikki Linnakangas wrote:
Florian G. Pflug wrote:
There could be a GUC vacuum_freeze_limit, and the actual FreezeLimit
would be calculated as
GetOldestXmin() - vacuum_freeze_limit
We already have that. It's called vacuum_freeze_min_age, and the default
is 100 million transactions.
IIRC we
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Exactly what will these allow that you can't do with inspection of ctid
> etc? (I suspect your answer will be "can't see infomask"
For testing the packed varlena stuff it would have been handy to be able to
see the length of tuples on disk. I made do with
Attatched you'll find a patch that I've been kicking around for a
while that I'd like to propose for inclusion in 8.3. I attempted to
submit this through the original xml2 author (as far back as the 7.4
days) but got no response.
It's really fairly trivial, but I will be using the features it
p
OK, with no feedback on this, I have removed the copied comments from
geo_ops.c, reorganized a little, and removed the GPL copyright notice.
Patch attached as unified diff so you can see the line changes easier.
Should this be backpatched to 8.2.X?
---
OK, patch reverted. Authors, would you please resubmit with fixes?
Thanks.
---
Tom Lane wrote:
> [EMAIL PROTECTED] (Bruce Momjian) writes:
> > Add GUC temp_tablespaces to provide a default location for temporary
> > object
Simon Riggs wrote:
I'll happily code it as functions or system cols or any other way, as
long as we can see everything there is to see.
With HOT, other useful information is about the line pointers. It would be
cool to be able to print the redirection info, details about LP_DELETEd
line poi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am playing with this now ... sorry for delay ...
- --On Wednesday, February 28, 2007 12:58:04 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Joshua D. Drake wrote:
>>> We should add this to the mailing list
18 matches
Mail list logo
