Re: Does Postgres ever write to tables without file system timestamps getting updated?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Guten Tag Thorsten Schöning,
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.

>From 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üßen,

Thorsten Schöning

-- 
Thorsten Schöning       E-Mail: Thorsten.Schoening@xxxxxxxxxx
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äftsführer: Andreas Muchow



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux