Postgres Pro
Downloads
Home   >   mailing lists

Best cache setting? - Mailing list pgsql-odbc

From Patrick Hatcher
Subject Best cache setting?
Date
Msg-id OFC62B8F8F.E25DFC92-ON8825727F.00666813-8825727F.00667D2C@FDS.com
Whole thread Raw
List pgsql-odbc
Tree view 
ODBC v:8.2

My queries routinely return 10K+ rows of data.  What would be the best
cache setting I can use to get the best throughput?  I have Declare/Fetch
set with a cache default of 100.  Should I turn off Declare/Fetch?

Thank you.

Patrick Hatcher

pgsql-odbc by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Creating a System DataSource dinamically
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1001906 ] Unable to obtain list of tables from the datasource