Reasonable fetch_size values when pairing with Redshift? - Mailing list pgsql-admin

From Wells Oliver
Subject Reasonable fetch_size values when pairing with Redshift?
Date
Msg-id CAOC+FBUbx+nRE0w28sK7AbijH9zEghmrHhqAYSxuXUfBLWOZ4w@mail.gmail.com
Whole thread Raw
List 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 by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Subject: Assistance Required: Adding Multiple Libraries to shared_preload_libraries in postgresql.conf
Next
From: James Pang
Date:
Subject: [MASSMAIL]cascading lock issue