Re: odbc parameters

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.

I don't know how you transfer the data. So it's hard to answer.

> UpdatableCursors=1

Do you need this?

> LFConversion=1

Are you sure you want CR/LF conversion?

> Parse=1

Do you need parse statements? I think you don't need one of
UpdatableCursors or Parse at least.

> Fetch=100

You don't need specify this while you have UseDeclareFetch = 0

> RowVersioning=1

Do you need RowVersioning?

> Could you suggest what parameters values would yield best performance for
> batch import to PostgreSQL?

Maybe this maybe someone suggest anothers. Let's experiment a little bit
yourself ;o)

Luf