Re: Archiving Data to Another DB? - Mailing list pgsql-general

From Don Seiler
Subject Re: Archiving Data to Another DB?
Date
Msg-id CAHJZqBAS8h18G7c7LbEnX1eRr15cojcf+GtHYESSkpUPxvuV4Q@mail.gmail.com
Whole thread Raw
In response to Re: Archiving Data to Another DB?  (Don Seiler <don@seiler.us>)
Responses RE: Archiving Data to Another DB?
List pgsql-general
On Wed, Apr 11, 2018 at 1:38 PM, Don Seiler <don@seiler.us> wrote:

Yeah, I saw the same with a 132 row insert. Now imagine that with a monthly 50 million row insert or delete. :p Thanks for the confirmation!

I went back to look at the postgres logs on my dev server. These logs are rotated once they hit 2G in size. One typical log from the middle of my test last night hit that in 13 minutes and had over 5.2 million DELETE calls. There a quite a few logs like this. That would not be fun for the disk space on the log volume, either.

Don.
--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PGto DB2
Next
From: "Kumar, Virendra"
Date:
Subject: RE: Archiving Data to Another DB?