On Fri, Aug 30, 2019 at 5:51 AM Durgamahesh Manne
wrote:
> Hi
> To respected international postgresql team
>
> I am using postgresql 11.4 version
> I have scheduled logical dump job which runs daily one time at db level
> There was one table that has write intensive activity for every 40 seconds
Hi,
Maybe - you can re-use this backup tricks.
"Speeding up dump/restore process"
https://www.depesz.com/2009/09/19/speeding-up-dumprestore-process/
for example:
"""
*Idea was: All these tables had primary key based on serial. We could
easily get min and max value of the primary key column, and
On Wed, Oct 16, 2019 at 3:22 PM Durgamahesh Manne
wrote:
>
>
> On Wed, Oct 16, 2019 at 3:09 PM Luca Ferrari wrote:
>
>> On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne
>> wrote:
>> > Is there any way to reduce dump time when i take dump of the table
>> which has 148gb in size without creati
On Wed, Oct 16, 2019 at 3:09 PM Luca Ferrari wrote:
> On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne
> wrote:
> > Is there any way to reduce dump time when i take dump of the table
> which has 148gb in size without creating partition* on that table has 148gb
> in size ?
>
> I would at least
On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne
wrote:
> Is there any way to reduce dump time when i take dump of the table which has
> 148gb in size without creating partiton on that table has 148gb in size ?
I would at least try a parallel dump: should it be -j option to pg_dump.
I'm not s
On Fri, Aug 30, 2019 at 4:12 PM Luca Ferrari wrote:
> On Fri, Aug 30, 2019 at 11:51 AM Durgamahesh Manne
> wrote:
> > Logical dump of that table is taking more than 7 hours to be completed
> >
> > I need to reduce to dump time of that table that has 88GB in size
>
> Good luck!
> I would see tw
On Fri, Aug 30, 2019 at 11:51 AM Durgamahesh Manne
wrote:
> Logical dump of that table is taking more than 7 hours to be completed
>
> I need to reduce to dump time of that table that has 88GB in size
Good luck!
I would see two possible solutions to the problem:
1) use physical backup and switc
