From: | ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Related to Foreign Table Accessing |
Date: | 2023-12-08 13:59:56 |
Message-ID: | CAKDb7aEZzyk9jHnL-u93fUY2efkWWviWbkJ9jzQg0abdJoKv1A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Team,
When I see the same query via pg_stat_activity it was hang on explain
statement.
How to handle this and moreover I found in docs there is a parameter I.e
analyze_sampling.
How to set this ?
On Thu, 30 Nov, 2023, 9:15 pm ROHIT SACHDEVA, <sachdeva(dot)rohit648(at)gmail(dot)com>
wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-12-08 14:47:45 | Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 |
Previous Message | Ron Johnson | 2023-12-08 13:03:34 | Re: Postgres storage migration |