Re: Strange assertion using VACOPT_FREEZE in vacuum.c

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Strange assertion using VACOPT_FREEZE in vacuum.c
Date: 2015-03-11 21:22:20
Message-ID: 5500B20C.9010509@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 3/11/15 3:57 PM, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
>> But autovacuum is still manufacturing a VacuumStmt by hand. If we want
>> to get rid of that, I think it'd work to have a new
>> ExecVacuum(VacuumStmt, params) function which is called from
>> standard_ProcessUtility and does just vacuum(rel, relid, params).
>> Autovacuum on the other hand can call vacuum() without having to
>> construct the parse node.
>
> Why would we want to get rid of that? A struct is a handy and legible
> way to pass a pile of parameters. I doubt it would be an improvement for
> vacuum() to grow a long list of separate parameters.

We're not exactly getting rid of it; Thomas' patch adds a second struct
that deals with detailed vacuum parameters that are not actually present
in VacuumStmt. These are things that are specific to autovac but not
manual VACUUM. But the patch in it's current form still have autovac
building a somewhat bogus VacuumStmt.

What's being proposed is to expose VacuumStmt (which only makes sense
for VACUUM) only where it's needed, and use VacuumParams everywhere
else. In particular, this means autovac will just deal with VacuumParams
and will no longer build a fake VacuumStmt.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-03-11 21:32:35 Re: Precedence of standard comparison operators
Previous Message Fabien COELHO 2015-03-11 21:21:23 Re: improve pgbench syntax error messages