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
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
in db
The size of the table is about 88GB
Logical dump of that table
