Re: [PATCHES] sum(int4)/sum(int2) improvement

2005-09-15 Thread Bruce Momjian
This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Atsushi Ogawa wrote: When sum(int4) or sum(int2) is executed, many cycles are spent by AllocSetReset. Because

Re: [PATCHES] sum(int4)/sum(int2) improvement

2005-09-15 Thread Bruce Momjian
Patch already applied in 8.1 in different way. --- Atsushi Ogawa wrote: When sum(int4) or sum(int2) is executed, many cycles are spent by AllocSetReset. Because per-tuple context is used to allocate the first data of

[PATCHES] small changes to autovacuum maintainance

2005-09-15 Thread Robert Treat
Attached patch takes a swing at improving the autovacuum wording in maintenance.sgml. On a related note I was thinking to add a note in the runtime config section for autovacuum_enabled that stats_start_collector and stats_row_level must be on for enabled to work, would that still go in

Re: [PATCHES] small changes to autovacuum maintainance

2005-09-15 Thread Tom Lane
Robert Treat [EMAIL PROTECTED] writes: On a related note to that, I am wondering if it might be better to have the postmaster issue a fatal error on startup if autovacuum is on and stats are off, rather than the warning it does now. Given that you can turn off the stats after startup, the