Re: [PERFORM] Bytea poor performance

2005-10-16 Thread NSO
.. 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

Re: [PERFORM] Bytea poor performance

2005-10-16 Thread NSO
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

Re: [PERFORM] Bytea poor performance

2005-10-15 Thread NSO
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

Re: [PERFORM] Bytea poor performance

2005-10-15 Thread NSO
> 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

Re: [PERFORM] Bytea poor performance

2005-10-15 Thread NSO
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

[PERFORM] Bytea poor performance

2005-10-15 Thread NSO
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