On Thursday 30 September 2010, Dann Corbit elucidated thus: > I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it > seems to perform wonderfully. I moved 1.5 million records that are 3K > wide from SQL*Server into PostgreSQL and rebuilt 6 indexes all in > less than 6 minutes.
> I was thinking of using SQLite for the project, > but I calculate the same data movement would have taken about one > month! This is a bit OT, but were you using transactions in SQLite? SQLite can deliver several thousand inserts per second if inside of a transaction. If you were only getting a few inserts per second, then you were not using transactions, thus SQLite was on "autocommit" mode, and thus committing after every insert, thus the performance penalty. j -- Joshua Kugler Part-Time System Admin/Programmer http://www.eeinternet.com - Fairbanks, AK PGP Key: http://pgp.mit.edu/ ID 0x73B13B6A -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
