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
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 files (file bytea, nr serial NOT NULL) WITH OIDS;
>
> Query:
> select * from files where nr > 1450
>
> (I have total 150
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 width=36)
(actual time=0.000..0.000 rows=50 loops=1)"
Have you done a full vacuum lately? How about reindexing?
Yes, I did reindexing
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 width=36)
> (actual time=0.000..0.000 rows=50 loops=1)"
I may not be under
Yes, it takes even up to 35 seconds.. I did the same query on the server
(not PC with was connected directly to server with 100mbit net), and /I
got better result it is 3.5 - 4 seconds, but it still not good.. Why it
is slow? and why the difference is so big? I mean from 4 to 35 seconds?
thx
>
"NSO" <[EMAIL PROTECTED]> writes:
> Query runs very long:
> Total query runtime: 23625 ms.
> Data retrieval runtime: 266 ms.
> 50 rows retrieved.
Notice that the query itself took 266ms. The rest of the time was
wasted by your client app trying to format a 23Kb by 50 row table
for display. You n
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 runs very long:
>> Total q
"NSO" <[EMAIL PROTECTED]> writes:
> 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).
That would suggest a networking problem, which is a bit outside my
expertise. If the client machine is running Windows, we
NSO wrote:
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.
Is this a web app? If so, then check you are using the s