doubts

From: Thomaz Luiz Santos <thomaz(dot)santos(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: doubts
Date: 2022-08-03 23:06:26
Message-ID: CAHtRPB6atN3u+dccSOjiJdYpNGEiTJqMrHCpZ4NZc+1F4jEaaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everybody!

scenari:
I need to refresh the data in one table, but I use one truncate to clean
the data and insert again the new data,

I have one question: is it possible to minimize the downtime for this
process ( because this table is large. ), using another strategy, like one
view and updating the view ?

Thank you
best regards.

--
------------------------------
Thomaz Luiz Santos
Linux User: #359356
http://thomaz.santos.googlepages.com/

Responses

  • Re: doubts at 2022-08-03 23:12:54 from David G. Johnston
  • Re: doubts at 2022-08-03 23:18:41 from Scott Ribe

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2022-08-03 23:12:54 Re: doubts
Previous Message Dan Smith 2022-08-03 12:09:13 Re: pgbackrest archive.info got deleted unexpected