pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Andres Freund <andres@anarazel.de>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Michael Paquier <michael.paquier@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: Reviewing freeze map code
Date: Fri, 1 Jul 2016 15:42:22 -0500
Message-ID: <c954f72f-6900-346e-d2fc-e9a7a3d0efcf@BlueTreble.com> (raw)
In-Reply-To: <20160701192351.s6revshsn2ir4szq@alap3.anarazel.de>
References: <CAD21AoDnjvPcmPTJhdgHRLho_mNADWupudMcd9=44rFsQdUe2A@mail.gmail.com>
	<CAA4eK1JK3amfqZaoKJYBkHCzeAYj2hdY_yB0b9o2_uDtJbaV7w@mail.gmail.com>
	<20160629170050.zpvcmaz3ni2y75d7@alap3.anarazel.de>
	<CAA4eK1+-Zjmb7mcHkQzWpQ_DOc3vAp0e0Bucx36gutp+Z-tjBQ@mail.gmail.com>
	<20160630034317.r7axkleum65u6t2l@alap3.anarazel.de>
	<CAA4eK1+19nb50V1tGRj93pvTK=pf9F0Xcp-xam9GsMwO4HuugQ@mail.gmail.com>
	<CAD21AoB4qeuCS=GeT3brf_fwcgMj+G0vKJvKqEsH1EzU699Fag@mail.gmail.com>
	<CAA4eK1K0aPO4tedf4X0fA6xoVB87PW-Z8dFFY+8Fo2r+AwfFBw@mail.gmail.com>
	<CAD21AoBgYuA2RM6+fYpYU1HT=Po9bOFytO43uUtoUe00UyASfg@mail.gmail.com>
	<CA+TgmoY8PdS9TxH35_OH9003_BYPj3_E14LiN6Kk5Ad8r_wi8A@mail.gmail.com>
	<20160701192351.s6revshsn2ir4szq@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 7/1/16 2:23 PM, Andres Freund wrote:
>> > The only
>> > cost of that is that vacuum will come along and mark the page
>> > all-visible again instead of skipping it, but that's probably not an
>> > enormous expense in most cases.
> I think the main cost is not having the page marked as all-visible for
> index-only purposes. If it's an insert mostly table, it can be a long
> while till vacuum comes around.

ISTM that's something that should be addressed anyway (and separately), no?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (256+ messages)  latest in thread

Message-ID: <c954f72f-6900-346e-d2fc-e9a7a3d0efcf@BlueTreble.com>
Permalink:  ../c954f72f-6900-346e-d2fc-e9a7a3d0efcf@BlueTreble.com/
Also on:    postgresql.org/message-id/c954f72f-6900-346e-d2fc-e9a7a3d0efcf@BlueTreble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: Jim.Nasby@BlueTreble.com, andres@anarazel.de, robertmhaas@gmail.com, sawada.mshk@gmail.com, amit.kapila16@gmail.com, alvherre@2ndquadrant.com, thomas.munro@enterprisedb.com, sfrost@snowman.net, michael.paquier@gmail.com
  Subject: Re: Reviewing freeze map code
  In-Reply-To: <c954f72f-6900-346e-d2fc-e9a7a3d0efcf@BlueTreble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox