Reasonable fetch_size values when pairing with Redshift?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Reasonable fetch_size values when pairing with Redshift?
Дата
Msg-id CAOC+FBUbx+nRE0w28sK7AbijH9zEghmrHhqAYSxuXUfBLWOZ4w@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
We use Redshift as a foreign server and I'm playing with the fetch_size value for testing various queries. Are there thoughts or tests to determine an ideal value? I have it set right now at 10000 and am thinking of making that 100000 but I'm wondering what my guardrails should be here.



--

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