Re: BUG #15179: Related to copy command
| От | Pavel Stehule |
|---|---|
| Тема | Re: BUG #15179: Related to copy command |
| Дата | |
| Msg-id | CAFj8pRCwBFj5d5GpokifhOY3uMY--p4dccQsertwQeyTcCN44w@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #15179: Related to copy command (PG Bug reporting form <noreply@postgresql.org>) |
| Список | pgsql-bugs |
Hi
2018-04-30 8:09 GMT+02:00 PG Bug reporting form <noreply@postgresql.org>:
Probably .. it is not PostgreSQL bug, but you are hit some Google cloud limit (maybe some throttling)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?
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 по дате отправления: