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
