Re: Related to Foreign Table Accessing

Hi Team,

When i run the same query via client it takes around 2 seconds and when it
is run at application side it is taking around 40 seconds

Examples
select animal_id from table where owner_id in ()
limit 200 offset 1600 -- takes 2 seconds
select animal_id from table where owner_id in ()
limit 200 offset 1800 --takes 40 seconds.

What will be this issue?

On Tue, Nov 28, 2023 at 2:08 PM ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
wrote:

> Hi Team,
> The application team is accessing a foreign table in batches of 200 rows,
> but the problem they are facing is that the query is taking different times
> for the same set of rows.
> The foreign table is only 1 shard with a partition of 21, and the
> partition we are using is a hash partition.
>
> What can I do at the database side to debug this or any configuration
> parameter related to this wired behavior?
> Have a Good day !!!
>
> Regards
> Rohit Sachdeva
>

--
Have a Good day !!!

Regards
Rohit Sachdeva