[PATCHES] Writing WAL for relcache invalidation: pg_internal.init

2006-10-27 Thread Simon Riggs
Enclose a patch for new WAL records for relcache invalidation. Not conclusively tested, but seems to work fine, so please regard this as a prototype-needs-review. We definitely need a regr test framework to support this type of patch. -- Simon Riggs EnterpriseDB http://www.en

Re: [HACKERS] [PATCHES] GUC description cleanup

2006-10-27 Thread Josh Berkus
Neil, > Sure, I'll wait for 8.3 to branch. I have some cleanup I want to do for 8.3 too. Josh Berkus PostgreSQL @ Sun San Francisco 415-752-2500 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] [PATCHES] WAL logging freezing

2006-10-27 Thread Simon Riggs
On Fri, 2006-10-27 at 22:19 +0100, Simon Riggs wrote: > So we definitely have a nasty problem here. > > VACUUM FREEZE is just a loaded gun right now. > > > Maybe it's OK to say that during WAL replay we keep it > > all the way back to the freeze horizon, but I'm not sure how we keep the > > syst

Re: [HACKERS] [PATCHES] WAL logging freezing

2006-10-27 Thread Simon Riggs
On Fri, 2006-10-27 at 12:01 -0400, Tom Lane wrote: > "Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I think it's premature to start writing > >> patches until we've decided how this really needs to work. > > > Not logging hint-bit updates seems safe to me. As long as we

Re: [HACKERS] [PATCHES] WAL logging freezing

2006-10-27 Thread Tom Lane
"Simon Riggs" <[EMAIL PROTECTED]> writes: > [I've just coded the relcache invalidation WAL logging patch also.] What? That doesn't make any sense to me. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the

Re: [PATCHES] WAL logging freezing

2006-10-27 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think it's premature to start writing >> patches until we've decided how this really needs to work. > Not logging hint-bit updates seems safe to me. As long as we have the > clog, the hint-bit is just a hint. The problem with

Re: [PATCHES] WAL logging freezing

2006-10-27 Thread Heikki Linnakangas
Tom Lane wrote: Heikki Linnakangas <[EMAIL PROTECTED]> writes: I would've liked to give freezing a new opcode, but we've ran out of them (see htup.h). Hardly ... we have plenty of unused rmgr id's still. Good point. The real issue that still has to be resolved is the interaction of all t

Re: [PATCHES] GUC description cleanup

2006-10-27 Thread Neil Conway
On Fri, 2006-10-27 at 15:59 +0200, Peter Eisentraut wrote: > I appreciate this effort, but I think it's better to hold the patch. Sure, I'll wait for 8.3 to branch. -Neil ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] GUC description cleanup

2006-10-27 Thread Peter Eisentraut
Am Donnerstag, 26. Oktober 2006 19:47 schrieb Neil Conway: > Note that this patch breaks the translations of these strings, so I > haven't applied it yet. Should I apply it now, or wait for 8.3 to > branch? I appreciate this effort, but I think it's better to hold the patch. -- Peter Eisentraut