Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)

Поиск
Список
Период
Сортировка
От Sai Teja
Тема Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)
Дата
Msg-id CADBXDMUV9xCjT2-cvaefVBoyYQiruHhuGR9ggZGd0jRRAd5emg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi Team,

We have bytea data stored in pg_largeobjects (Large objects table)

Here , the data is 675 MB. We are using Large objects client interface API provided by postgreSQL to retrieve the data (lo_read, lo_open etc)

When I try to fetch the data from local it took 30-35 sec to retrieve the content from DB. 
Whereas, azure postgreSQL is keep on executing even it is more than 1hr.

I'm using Java code to retrieve the data as you can see that code, network speed everything is same but when I point to azure postgreSQL the latency is very high.

If anyone knows what can be root cause or how can I retrieve the file like local. It would help me a lot and appreciated.

Azure postgreSQL version: 14.8 - Hosted in Germany west
Local postgreSQL version: 15.1 - Hosted in India

Even script ran in Germany (I thought network latency/region is the issue) there is still high latency.

I request to please suggest any ideas/solution to resolve this issue.

Thanks,
Sai


В списке pgsql-general по дате отправления:

Предыдущее
От: "Pete O'Such"
Дата:
Сообщение: Re: PG FDW query fails, works local, same credentials
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)