Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org,pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Date: 2005-03-14 02:52:19
Message-ID: 200503140252.j2E2qJa19705@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-patches
Ron Mayer wrote:
> Bruce Momjian wrote:
> > 
> > You didn't like server_min_messages = 'notify'?
> 
> I merely don't have a feeling for how much additional stuff
> verbose would be putting in the log files.

You will probably see the creation of indexes and sequences, like this:
	
	test=> create table test(x int primary key);
	NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
	"test_pkey" for table "test"

> If it's a good practice for production systems to be logging
> NOTIFY's I'm happy with the change.

Not really.  The FSM message has a lot more interest than the other
NOTIFY messages.

> My reasoning why I thought the log file was more useful was
> that only an admin with access to the log files could really
> do anything about the message anyway.

The log file is useful, but I think showing the VACUUM user is _more_
useful than the log file.

> Also since the message happing occasionally is probably OK,
> yet if it happens a lot it's more likely worth looking
> into - I think the historical record of when it happened
> is more interesting than a one-time occurrence which is
> all you seen in the active session.

Seems it could be made to be both client and log, but I can't think of
any case were we do that now, and am unsure it is a good idea to add it
just for this.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-03-14 02:52:47
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are
Previous:From: Bruce MomjianDate: 2005-03-14 02:24:33
Subject: Re: CC Date format code defaults to current centry

pgsql-general by date

Next:From: Bruce MomjianDate: 2005-03-14 02:52:47
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are
Previous:From: Klint GoreDate: 2005-03-14 02:44:51
Subject: Re: sql question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group