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

Started by Sai Tejaover 2 years ago2 messagesgeneral
Jump to latest
#1Sai Teja
saitejasaichintalapudi@gmail.com

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

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Sai Teja (#1)
Re: Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)

On 9/1/23 07:22, Sai Teja wrote:

Hi Team,

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

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.

This is question for Azure tech support. Contact them.

Thanks,
Sai

--
Adrian Klaver
adrian.klaver@aklaver.com