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 i

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

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 cont

Re: PG FDW query fails, works local, same credentials

> Check your search path assumptions. postgres_fdw runs remote > queries with a very minimal search_path setting, Indeed it was the search path, combined with references to user-defined functions that weren't schema-qualified. Thank you for the pointer! -Pete On Thu, Aug 31, 2023 at 12:46 AM T