Hi, Ferreira, FERREIRA, William (VALTECH) wrote:
> i load data from files using copy method. > Files contain between 2 and 7 millions of rows, spread on 5 tables. > > For loading all the data, it takes 40mn, and the same processing takes 17mn > with Oracle. > I think that this time can be improved by changing postgresql configuration > file. > But which parameters i need to manipulate and with which values ? Increase the size of the wal. If its just a develpoment environment, or you don't mind data inconsistency in case of a crash, disable fsync. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
