>but did you try to execute your query directly from 'psql' ?...
munnin=>select * from "tblItem";
Time: 391,000 ms
>Why I'm asking: seems to me your case is probably just network latency
>dependent, and what I noticed during last benchmarks with PostgreSQL
>the SELECT query become very traffic hungry if you are using CURSOR.
>Program 'psql' is implemented to not use CURSOR by default, so it'll
>be easy to check if you're meeting this issue or not just by executing
>your query remotely from 'psql'...
Yes, see also my other post.
Unfortunatelly this means that using my program to connect via DSL to the
Postgres database is not possible.
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2007-06-21 22:29:15|
|Subject: Re: Hardware suggestions|
|Previous:||From: Dimitri||Date: 2007-06-21 21:32:01|
|Subject: Re: Data transfer very slow when connected via DSL|