This problem was caused by the OleDb driver. I used a 3rd party .NET
provider and it worked, 8000 rows in just over 100ms!
Can somebody send me a sample connection string for the PostGreSql native
.net driver please? I'm battling to find a valid connection string.
In response to
pgsql-performance by date
|Next:||From: Gavin Hamill||Date: 2006-03-30 08:26:13|
|Subject: CREATE INDEX rather sluggish|
|Previous:||From: Josh Berkus||Date: 2006-03-30 05:18:49|
|Subject: Re: Query using SeqScan instead of IndexScan|