Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15179: Related to copy command - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #15179: Related to copy command
Date
Msg-id CAFj8pRCwBFj5d5GpokifhOY3uMY--p4dccQsertwQeyTcCN44w@mail.gmail.com
Whole thread Raw
In response to BUG #15179: Related to copy command  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
Hi

2018-04-30 8:09 GMT+02:00 PG Bug reporting form <noreply@postgresql.org>:
The following bug has been logged on the website:

Bug reference:      15179
Logged by:          Vaishali Kulkarni
Email address:      vaishali.kk@gmail.com
PostgreSQL version: 9.5.12
Operating system:   linux-gnu
Description:       

Copy command on AWS takes 5 minutes to copy 80mb data but takes 20 minutes
on Google cloud server, what should I check to fix this issue?

 
Probably .. it is not PostgreSQL bug, but you are hit some Google cloud limit (maybe some throttling)

Generally - cloud services without explicitly dedicated databases support has bad performance.

You can check:

1. available memory
2. CPU speed (you can run some CPU benchmark)
3. IO speed (there are some benchmarks like bonie++).

Regards

Pavel

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15179: Related to copy command
Next
From: PG Bug reporting form
Date:
Subject: BUG #15180: Alter table add column if not exists with uniqueconstraint will add extra duplicate