From: | "Joshua J(dot) Kugler" <joshua(at)eeinternet(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Dann Corbit <DCorbit(at)connx(dot)com> |
Subject: | Re: Kudos on the 64 bit PostgreSQL for Windows |
Date: | 2010-10-01 17:35:38 |
Message-ID: | 201010010935.39203.joshua@eeinternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2010-10-01 18:06:23 | Re: Kudos on the 64 bit PostgreSQL for Windows |
Previous Message | Alban Hertroys | 2010-10-01 17:09:23 | Re: Bit-wise foreign keys |