Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group