Related to Foreign Table Accessing

Поиск
Список
Период
Сортировка
От ROHIT SACHDEVA
Тема Related to Foreign Table Accessing
Дата
Msg-id CAKDb7aG0jbhpSoLNv2G9P2FNUuLd2W6r=tyTNHBDiPLp3q=K5Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Related to Foreign Table Accessing  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
Список pgsql-admin

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

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: pg_dump -Are statistics saved?
Следующее
От:
Дата:
Сообщение: logical replication with stream replication