Re: [PATCHES] [DOCS] Autovacuum and XID wraparound
Neil Conway wrote: > On Mon, 2007-14-05 at 16:22 -0400, Bruce Momjian wrote: > > I agree with Tom. I don't think the current behavior is a major issue > > for users for it to be mentioned more than it already is > > Are you really suggesting that we shouldn't modify config.sgml to note > that "autovacuum = off" does not actually imply that "the autovacuum > daemon is disabled"? ISTM that plainly violates the principle of least > surprise -- it is almost the definition of what an entry in config.sgml > *should* include. I agree, the note should be added there (but it should be a short one and refer the reader someplace else for more complete details). Was there a doc patch proposed already? I seem to have missed it. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [PATCHES] [DOCS] Autovacuum and XID wraparound
On Tue, 2007-15-05 at 09:07 -0400, Alvaro Herrera wrote: > I agree, the note should be added there (but it should be a short one > and refer the reader someplace else for more complete details). I've applied the attached patch to HEAD and REL8_2_STABLE. -Neil Index: doc/src/sgml/config.sgml === RCS file: /home/neilc/postgres/cvs_root/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.122 diff -c -p -r1.122 config.sgml *** doc/src/sgml/config.sgml 20 Apr 2007 02:37:37 - 1.122 --- doc/src/sgml/config.sgml 15 May 2007 15:04:35 - *** SELECT * FROM parent WHERE key = 2400; *** 3172,3177 --- 3172,3183 This parameter can only be set in the postgresql.conf file or on the server command line. + + Note that even when this parameter is disabled, the system + will periodically launch autovacuum processes in order to + prevent transaction ID wraparound. See for more information. + ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] [DOCS] OS/X startup scripts
On Tue, May 15, 2007 at 03:35:45PM +1200, Mark Kirkwood wrote: > Alvaro Herrera wrote: > >Mark Kirkwood wrote: > >>Alvaro Herrera wrote: > > > >>>Except that it also includes diffs for generated files, which tend to be > >>>huge. To work around that you need to create a list of files to > >>>exclude, and the whole thing (which was cumbersome already) starts to > >>>get unmanageable. > >>$ make maintainer-clean > >> > >>before the diff, which clears all those out. > > > >Yeah, but then if you make a mistake with the patch and have to build > >again to retest, you have to wait the whole thing to compile, which can > >be annoying. > > > > True - depends on the speed of your machine as to how annoying this > really is... (I'm using a PIII 1.26 GHz... takes 5 min with -O2 - good > excuse for a coffee etc). > > However, as David brought up previously it is probably worth mentioning > several of the various CVS work-arounds in the docs, so people at least > get a good survey of the options - they can then choose whichever suits > their needs best. +1... BTW, is there some trick to getting cvs diff to ignore files that aren't in the repo? -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
