Kudos on the 64 bit PostgreSQL for Windows

From: Dann Corbit <DCorbit(at)connx(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Kudos on the 64 bit PostgreSQL for Windows
Date: 2010-09-30 22:35:11
Message-ID: 87F42982BF2B434F831FCEF4C45FC33E4201CCD0@EXCHANGE.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!
The memory footprint is also very nice for the amount of performance delivered.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2010-09-30 22:45:28 Re: Hosting options?
Previous Message Merlin Moncure 2010-09-30 20:59:46 Re: libpq (C++) - Insert binary data