On 2/10/2010 9:41 AM, Dann Corbit wrote:
The inserts are processed via an INSERT/SELECT statement.
A custom driver has been written that performs this operation
using the COPY API.
BTW, is there any chance you can push that (ODBC, you said?) driver
somewhere public? It might interest the psql
On 2/10/2010 9:41 AM, Dann Corbit wrote:
The inserts are processed via an INSERT/SELECT statement.
A custom driver has been written that performs this operation
using the COPY API.
Aaah, so it's not really sending individual INSERT statements to the
database at all, you're using COPY behind t
> -Original Message-
> From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
> Sent: Friday, October 01, 2010 6:08 PM
> To: Dann Corbit
> Cc: 'Joshua J. Kugler'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Kudos on the 64 bit PostgreSQL for Windo
> -Original Message-
> From: Dann Corbit
> Sent: Friday, October 01, 2010 11:06 AM
> To: 'Joshua J. Kugler'; pgsql-general@postgresql.org
> Subject: RE: Kudos on the 64 bit PostgreSQL for Windows
>
> > -Original Message-
> > From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
> >
On 2/10/2010 2:06 AM, Dann Corbit wrote:
>> 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, thu
> -Original Message-
> From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
> Sent: Friday, October 01, 2010 10:36 AM
> To: pgsql-general@postgresql.org
> Cc: Dann Corbit
> Subject: Re: Kudos on the 64 bit PostgreSQL for Windows
>
> On Thursday 30 September 2010, Dann Corbit elucidated th
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 w
