.. is
server can't send faster? or client is not accepting data faster?
> NSO wrote:
>
>>Hello,
>>
>> No it is not web app, I tested on simple delphi app and with PGAdmin
>>III.. same results.. Query from PGAdmin takes up to 30seconds...
>>
>>
> Displa
Hello,
No it is not web app, I tested on simple delphi app and with PGAdmin
III.. same results.. Query from PGAdmin takes up to 30seconds...
> NSO wrote:
>> Hello,
>>
>> Yes, I can understand that, but then why the same app on the server
>> machine is done in 4 secon
Hello,
Yes, I can understand that, but then why the same app on the server
machine is done in 4 seconds? (big difference from 20-30 seconds). I
tryed to monitor network traffic and it is used only for 1-2% of total
100mbit.
> "NSO" <[EMAIL PROTECTED]> writes:
>> Query
> On 10/15/05 10:00 AM, "NSO" <[EMAIL PROTECTED]> wrote:
>
>> Hello,
>>
>> How about some explain analyze output?
>> Explain analyse select * from files where nr > 1450
>>
>> "Index Scan using pk on files (cost=0.00..3.67 rows=50
id reindexing and vacuum full just before query..
> On 10/15/05 9:20 AM, "NSO" <[EMAIL PROTECTED]> wrote:
>
>> Hello,
>>
>> I am trying to select form table with bytea field. And queries runs very
>> slow.
>> My table:
>> CREATE TABLE f
Hello,
I am trying to select form table with bytea field. And queries runs very
slow.
My table:
CREATE TABLE files (file bytea, nr serial NOT NULL) WITH OIDS;
Query:
select * from files where nr > 1450
(I have total 1500 records in it, every holds picture of 23kB size)
Query runs very long:
Tot