Hello SQLite should be faster in single user test - it is optimized for this purpose. So you cannot to get same speed from PostgreSQL Pavel 2012/2/23 Dmytrii Nagirniak <dnagir@xxxxxxxxx>: > > > On 23/02/2012, at 4:38 PM, Jan Kesten wrote: > > Hi Dmytrii, > > just as short idea, put "fsync = off" in your postgres.conf. That turns off > that after a commit data is forcilby written to disk - if the database > crashes there might be dataloss. > > > Thanks. So far I tried: > > fsync = off > full_page_writes = off > > It seems it got a *little* faster (down to ~65 seconds from ~76) but is till > too far from my target of ~34 secs. > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
