Horton

Re: New VACUUM FULL

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: Josh Berkus <josh@agliodbs.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Simon Riggs <simon@2ndQuadrant.com>, Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>, Tom Lane <tgl@sss.pgh.pa.us>, Jeff Davis <pgsql@j-davis.com>, Alvaro Herrera <alvherre@commandprompt.com>, pgsql-hackers@postgresql.org
Date: 2010-01-05T00:19:20Z
Lists: pgsql-hackers 
> I think I'd vote for throwing an ERROR.  By the time you see the
> WARNING it may be too late.  Since this is only for emergencies, the
> user can shut off recovery_connections first if they really need it.

I'm with Robert on this one.  If running VFI will cause unrecoverable
failure on the slave, it should be prevented.

If this is only an issue with system tables, then we only need to error
on system tables.

--Josh