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>:
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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15179: Related to copy command
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15180: Alter table add column if not exists with uniqueconstraint will add extra duplicate