Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dIEy5-0001Om-CS for pgsql-admin@arkaria.postgresql.org; Tue, 06 Jun 2017 13:56:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dIEy4-0001aK-Pm for pgsql-admin@arkaria.postgresql.org; Tue, 06 Jun 2017 13:56:20 +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 1dIEy4-0001Zy-B3 for pgsql-admin@postgresql.org; Tue, 06 Jun 2017 13:56:20 +0000 Received: from mail.am-soft.de ([83.218.36.120]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dIEy1-0002Ro-0s for pgsql-admin@postgresql.org; Tue, 06 Jun 2017 13:56:19 +0000 Received: from tschoening-nb.fritz.box (dslb-094-222-229-253.094.222.pools.vodafone-ip.de [94.222.229.253]) by mail.am-soft.de (Postfix) with ESMTP id B6801EF1E9 for ; Tue, 6 Jun 2017 15:56:15 +0200 (CEST) Date: Tue, 6 Jun 2017 15:56:14 +0200 From: =?utf-8?Q?Thorsten_Sch=C3=B6ning?= Organization: AM-SoFT IT-Systeme Message-ID: <08328348.20170606155614@am-soft.de> To: pgsql-admin@postgresql.org Subject: Re: Does Postgres ever write to tables without file system timestamps getting updated? In-Reply-To: <1599962113.20170606153203@am-soft.de> References: <143511646.20170606100454@am-soft.de> <1599962113.20170606153203@am-soft.de> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Guten Tag Thorsten Sch=C3=B6ning, am Dienstag, 6. Juni 2017 um 15:32 schrieben Sie: > The file belongs to pg_largeobject and that table contains a lot of > data, hence the named suffixes. Most of those files in the sequence > have old timestamps like the one above, more than a few days without > any writing, and are NOT all backed up and have the same MD5 hash like > in my backup. Only few files once a while differ like the one in the > example. =46rom the following very old data files, mostly unchanged for days/weeks, e.g. 2613.13 got transferred because of different checksums, while 2613.10 didn't: > -rw------- 1 postgres postgres 1073741824 Jun 4 04:40 2613 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:42 2613.1 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:56 2613.10 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:57 2613.11 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:57 2613.12 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:58 2613.13 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:59 2613.14 > -rw------- 1 postgres postgres 1073741824 Mai 28 04:40 2613.15 > -rw------- 1 postgres postgres 686645248 Jun 4 04:42 2613.16 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:44 2613.2 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:46 2613.3 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:47 2613.4 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:49 2613.5 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:50 2613.6 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:52 2613.7 > -rw------- 1 postgres postgres 1073741824 Mai 21 04:53 2613.8 > -rw------- 1 postgres postgres 1073741824 Jun 4 04:40 2613.9 > -rw------- 1 postgres postgres 4407296 Jun 4 04:42 2613_fsm > -rw------- 1 postgres postgres 548864 Jun 4 04:42 2613_vm Mit freundlichen Gr=C3=BC=C3=9Fen, Thorsten Sch=C3=B6ning --=20 Thorsten Sch=C3=B6ning E-Mail: Thorsten.Schoening@AM-SoFT.de AM-SoFT IT-Systeme http://www.AM-SoFT.de/ Telefon...........05151- 9468- 55 Fax...............05151- 9468- 88 Mobil..............0178-8 9468- 04 AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB 207 694 - Gesch=C3=A4ftsf=C3=BChrer: Andreas Muchow --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin