doubts - Mailing list pgsql-admin

From Thomaz Luiz Santos
Subject doubts
Date
Msg-id CAHtRPB6atN3u+dccSOjiJdYpNGEiTJqMrHCpZ4NZc+1F4jEaaw@mail.gmail.com
Whole thread Raw
Responses Re: doubts  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: doubts  (Scott Ribe <scott_ribe@elevated-dev.com>)
List 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/

pgsql-admin by date:

Previous
From: Dan Smith
Date:
Subject: Re: pgbackrest archive.info got deleted unexpected
Next
From: "David G. Johnston"
Date:
Subject: Re: doubts