Re: Slow performance on Windows .NET and OleDb

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Greg Quinn <greg(at)officium(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: 2006-03-29 11:21:15
Message-ID: 442A6DAB.5020404@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2006-03-29 11:40:54 Re: Slow performance on Windows .NET and OleDb
Previous Message Greg Quinn 2006-03-29 11:00:20 Re: Slow performance on Windows .NET and OleDb