Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow performance on Windows .NET and OleDb - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Slow performance on Windows .NET and OleDb
Date
Msg-id 442A6DAB.5020404@logix-tt.com
Whole thread Raw
In response to Re: Slow performance on Windows .NET and OleDb  ("Greg Quinn" <greg@officium.co.za>)
List pgsql-performance
Tree view 
Hi, Greg,

Greg Quinn wrote:
>>> I populate 3000 records into the table to test PostGreSql's speed.
>>> It takes about 3-4 seconds.
>> When you do the population, is it via inserts or copy?
> Via insert

Are those inserts encapsulated into a single transaction? If not, that's
the reason why it's so slow, every transaction sync()s through to the disk.

Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: "Greg Quinn"
Date:
Subject: Re: Slow performance on Windows .NET and OleDb
Next
From: PFC
Date:
Subject: Re: Slow performance on Windows .NET and OleDb