Bytea poor performance

From: "NSO" <nso(at)fmf(dot)vtu(dot)lt>
To: pgsql-performance(at)postgresql(dot)org
Subject: Bytea poor performance
Date: 2005-10-15 13:20:54
Message-ID: 17260.81.7.89.65.1129382454.squirrel@fmf.vtu.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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:
Total query runtime: 23625 ms.
Data retrieval runtime: 266 ms.
50 rows retrieved.

explain:
Index Scan using pk on files (cost=0.00..3.67 rows=50 width=36)
Index Cond: (nr > 1450)

Is it possible to do something with it? or it is normal? Our server is
fast, and all other tables work fine..

--
This message has been scanned for viruses and
dangerous content, and is believed to be clean.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sean Davis 2005-10-15 13:40:28 Re: Bytea poor performance
Previous Message Craig A. James 2005-10-14 22:31:59 tsearch2/GIST performance factors?