Re: Archiving Data to Another DB?

[Don Seiler <don@xxxxxxxxx>]

On Wed, Apr 11, 2018 at 1:38 PM, Don Seiler <don@xxxxxxxxx> 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