Re: Purging few months old data and vacuuming in production

On Fri, Dec 30, 2022 at 12:09 PM Ranjith Paliyath wrote: > Hi, > > We have a PostgreSQL (slightly old version, something like - PostgreSQL > 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat > 4.8.5-36), 64-bit) production, where one particular table and its related 5 > t

Re: Purging few months old data and vacuuming in production

Hi, I think partitioning will be a good option, you can easily detach partitions will minimal time. Regards, Inzamam Shafiq Sr. DBA From: Ranjith Paliyath Sent: Friday, December 30, 2022 11:39 AM To: pgsql-general@lists.postgresql.org Subject: Purging few mont

Purging few months old data and vacuuming in production

Hi, We have a PostgreSQL (slightly old version, something like - PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit) production, where one particular table and its related 5 tables need to be purged of 3 months prior data. Each of these table

Re: https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated.

Hi, jian he , 28 Ara 2022 Çar, 13:01 tarihinde şunu yazdı: > the last command should return nothing? > No, a patch file is not the same with diff output. Patches in the mailing list mostly include some meta information like commit message, commit date, author name etc. in addition to diff. That'