Skip site navigation (1) Skip section navigation (2)

odbc parameters

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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. 


In response to

Responses

pgsql-odbc by date

Next:From: A. KretschmerDate: 2007-07-11 12:31:54
Subject: Re: odbc parameters
Previous:From: Tom AllisonDate: 2007-07-11 10:24:35
Subject: Re: Duplicate Unique Key constraint error

pgsql-general by date

Next:From: A. KretschmerDate: 2007-07-11 12:31:54
Subject: Re: odbc parameters
Previous:From: Peter EisentrautDate: 2007-07-11 12:06:53
Subject: Re: Day of week vs. Language

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group