Hi,
We are in the process of migrating an oracle database to postgres in Google
Cloud and are investigating backup/recovery tools. The database is size is
> 20TB. We have an SLA that requires us to be able to complete a full
restore of the database within 24 hours. We have been testing
On Thu, Dec 5, 2019 at 9:48 AM Craig Jackson
wrote:
> Hi,
>
> We are in the process of migrating an oracle database to postgres in
> Google Cloud and are investigating backup/recovery tools. The database is
> size is > 20TB. We have an SLA that requires us to be able to complete a
> full restore
Thanks, I'll check it out.
On Thu, Dec 5, 2019 at 12:51 PM Craig James wrote:
> On Thu, Dec 5, 2019 at 9:48 AM Craig Jackson
> wrote:
>
>> Hi,
>>
>> We are in the process of migrating an oracle database to postgres in
>> Google Cloud and are investigating backup/recovery tools. The database is
On Thu, Dec 5, 2019 at 3:26 PM Mike Schanne wrote:
> I am concerned that if the autovacuum is constantly canceled, then the
> table never gets cleaned and its performance will continue to degrade over
> time. Is it expected for the vacuum to be canceled by an insert in this
> way?
>
>
>
> We
Mike Schanne writes:
> I am investigating a performance problem in our application and am seeing
> something unexpected in the postgres logs regarding the autovacuum.
> 2019-12-01 13:05:39.029
> UTC,"wb","postgres",6966,"127.0.0.1:53976",5ddbd990.1b36,17099,"INSERT
> waiting",2019-11-25
On Thu, Dec 5, 2019 at 5:26 PM Mike Schanne wrote:
> Hi,
>
> I am investigating a performance problem in our application and am seeing
> something unexpected in the postgres logs regarding the autovacuum.
>
>
>
> 2019-12-01 13:05:39.029
>
Hi
I have a function that prepares data, so the big job can be run it in parallel.
Today I have solved this by using "Gnu parallel" like this.
psql testdb -c"\! psql -t -q -o /tmp/run_cmd.sql testdb -c\"SELECT