Re: Kudos on the 64 bit PostgreSQL for Windows

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