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

Re: Slow performance on Windows .NET and OleDb

From: PFC <lists(at)peufeu(dot)com>
To: "Greg Quinn" <greg(at)officium(dot)co(dot)za>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: 2006-03-29 11:40:54
Message-ID: op.s66aqgokcigqcu@apollo13 (view raw or flat)
Thread:
Lists: pgsql-performance
> 3000 Rows - 7 seconds - very slow

	On my PC (athlon 64 3000+ running Linux), selecting 3000 rows with 4  
columns out of a 29 column table takes about 105 ms, including time to  
transfer the results and convert them to native Python objects. It takes  
about 85 ms on a test table with only those 4 columns.

	There is definitely a problem somewhere on your system.

	I'd suggest running this query in an infinite loop. Logically, it should  
use 100% processor, with postgres using some percentage (30% here) and  
your client using some other percentage (70% here). Is your processor used  
to the max ?

In response to

pgsql-performance by date

Next:From: Gábriel ÁkosDate: 2006-03-29 12:22:32
Subject: statistics buffer is full
Previous:From: Markus SchaberDate: 2006-03-29 11:21:15
Subject: Re: Slow performance on Windows .NET and OleDb

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