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

help / color / mirror / Atom feed
From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Greg Spiegelberg <gspiegelberg@gmail.com>
Cc: Alex Ignatov (postgrespro) <a.ignatov@postgrespro.ru>
Cc: Terry Schmitt <tschmitt@schmittworks.com>
Cc: pgsql-performa. <pgsql-performance@postgresql.org>
Subject: Re: Millions of tables
Date: Sat, 8 Oct 2016 16:42:01 -0500
Message-ID: <bce33408-16f1-fb5d-671a-f73072c83bc3@BlueTreble.com> (raw)
In-Reply-To: <CAEtnbpXbKBR1Hp_prQWNMbCDLVWn0Upo6V3_c83f+XFJ-aKNQA@mail.gmail.com>
References: <CAEtnbpVXi0ESh16KAeYkFOiFPhTrJ2JXps9PypuAGCYidWtcnA@mail.gmail.com>
	<CAOOcyszVahTaU8c9OPbnfw4nDtS8YObEy75+afhiFApEV7WJwQ@mail.gmail.com>
	<CAEtnbpUV2sgOhJfQYzT4AfnOUb_=XM9ReSGhCdzZo08SUcOUTQ@mail.gmail.com>
	<001401d21a42$2d21a8b0$8764fa10$@postgrespro.ru>
	<b4b058f0-e81b-047f-c714-5f0c4f693b99@BlueTreble.com>
	<CAEtnbpXbKBR1Hp_prQWNMbCDLVWn0Upo6V3_c83f+XFJ-aKNQA@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On 10/5/16 7:34 AM, Greg Spiegelberg wrote:
> When you say "must do a vacuum of the entire database", are you saying
> the entire database must be vacuum'd as a whole per 2B transactions or
> all tables must be vacuum'd eventually at least once?

All tables at least once. Prior to 9.6, that had to happen ever 2B 
transactions. With 9.6 there's a freeze map, so if a page never gets 
dirtied between vacuum freeze runs then it doesn't need to be frozen.
-- 
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-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (42+ messages)  latest in thread

Message-ID: <bce33408-16f1-fb5d-671a-f73072c83bc3@BlueTreble.com>
Permalink:  ../bce33408-16f1-fb5d-671a-f73072c83bc3@BlueTreble.com/
Also on:    postgresql.org/message-id/bce33408-16f1-fb5d-671a-f73072c83bc3@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-performance@postgresql.org
  Cc: Jim.Nasby@BlueTreble.com, gspiegelberg@gmail.com, a.ignatov@postgrespro.ru, tschmitt@schmittworks.com
  Subject: Re: Millions of tables
  In-Reply-To: <bce33408-16f1-fb5d-671a-f73072c83bc3@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