Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aymtL-0002wz-T5 for pgsql-hackers@arkaria.postgresql.org; Fri, 06 May 2016 21:02:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aymtL-0006Bf-FP for pgsql-hackers@arkaria.postgresql.org; Fri, 06 May 2016 21:02:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ayms0-0003qe-1r for pgsql-hackers@postgresql.org; Fri, 06 May 2016 21:01:08 +0000 Received: from www.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aymrv-0003cG-Gb for pgsql-hackers@postgresql.org; Fri, 06 May 2016 21:01:06 +0000 Received: from [192.168.1.60] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 50FE63A9; Fri, 6 May 2016 14:01:00 -0700 (PDT) Received: from c-73-225-27-179.hsd1.wa.comcast.net ([73.225.27.179] helo=[192.168.1.60]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.4.5); 6 May 2016 14:01:00 -0700 Subject: Re: Reviewing freeze map code To: Stephen Frost References: <20160502214818.psk3lmgyihk6gr3k@alap3.anarazel.de> <20160505000840.epatoq6d2e556446@alap3.anarazel.de> <572D0309.4090402@commandprompt.com> <20160506205012.ipuhvctss2ozzs6m@alap3.anarazel.de> <572D0471.3040009@commandprompt.com> <20160506205821.GE10850@tamriel.snowman.net> Cc: Andres Freund , Robert Haas , Masahiko Sawada , "pgsql-hackers@postgresql.org" From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <572D060B.5050503@commandprompt.com> Date: Fri, 6 May 2016 14:00:59 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2 MIME-Version: 1.0 In-Reply-To: <20160506205821.GE10850@tamriel.snowman.net> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.4.5(15162) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-68460-09194 X-Assp-Session: 7FC103EE2E38 (mail 1) X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-hackers@postgresql.org X-Assp-Intended-For: sawada.mshk@gmail.com X-Assp-Intended-For: robertmhaas@gmail.com X-Assp-Intended-For: andres@anarazel.de X-Assp-Intended-For: sfrost@snowman.net X-Assp-Original-Subject: Re: [HACKERS] Reviewing freeze map code X-Assp-Client-SSL: yes X-Pg-Spam-Score: -4.0 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 05/06/2016 01:58 PM, Stephen Frost wrote: > * Joshua D. Drake (jd@commandprompt.com) wrote: >> Yeah I thought about that, it is the word "FORCE" that bothers me. >> When you use FORCE there is an assumption that no matter what, it >> plows through (think rm -f). So if we don't use FROZEN, that's cool >> but FORCE doesn't work either. > > Isn't that exactly what this FORCE option being contemplated would do > though? Plow through the entire relation, regardless of what the VM > says is all frozen or not? > > Seems like FORCE is a good word for that to me. Except that we aren't FORCING a vacuum. That is the part I have contention with. To me, FORCE means: No matter what else is happening, we are vacuuming this relation (think locks). But I am also not going to dig in my heals. If that is truly what -hackers come up with, thank you at least considering what I said. Sincerely, JD > > Thanks! > > Stephen > -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers