| From: | "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org>, "Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | odbc parameters |
| Date: | 2007-07-11 12:15:02 |
| Message-ID: | 001301c7c3b5$1ccb4950$9bb80fd4@zlatkovyfkpgz6 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Hello,
I use MS Access for data import. Access imports csv file, make some
calculation and transffers data to PostgreSQL.
Unfortunately, it takes a lot of time to transfer data to PostgreSQL.
My odbc settings are following:
[ODBC]
DRIVER=PostgreSQL Unicode
UID=postgres
XaOpt=1
LowerCaseIdentifier=0
UseServerSidePrepare=1
ByteaAsLongVarBinary=0
BI=0
TrueIsMinus1=0
DisallowPremature=1
UpdatableCursors=1
LFConversion=1
ExtraSysTablePrefixes=dd_
CancelAsFreeStmt=0
Parse=1
BoolsAsChar=0
UnknownsAsLongVarchar=0
TextAsLongVarchar=1
UseDeclareFetch=0
Ksqo=1
Optimizer=1
CommLog=0
Debug=0
MaxLongVarcharSize=8190
MaxVarcharSize=255
UnknownSizes=0
Socket=4096
Fetch=100
ConnSettings=
ShowSystemTables=0
RowVersioning=1
ShowOidColumn=0
FakeOidIndex=0
Protocol=7.4-1
ReadOnly=0
SSLmode=allow
PORT=5432
SERVER=localhost
DATABASE=PLANINGZ
Could you suggest what parameters values would yield best performance for
batch import to PostgreSQL?
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-07-11 12:31:54 | Re: odbc parameters |
| Previous Message | Peter Eisentraut | 2007-07-11 12:06:53 | Re: Day of week vs. Language |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-07-11 12:31:54 | Re: odbc parameters |
| Previous Message | Tom Allison | 2007-07-11 10:24:35 | Re: Duplicate Unique Key constraint error |