Message-ID: <17260.81.7.89.65.1129382454.squirrel@fmf.vtu.lt>
Date: Sat, 15 Oct 2005 16:20:54 +0300 (EEST)
Subject: Bytea poor performance
From: "NSO" <nso@fmf.vtu.lt>
To: pgsql-performance@postgresql.org
User-Agent: SquirrelMail/1.4.5
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit
Importance: Normal
X-VGTU-MailScanner-OpenProtect-Information: Please contact the ISP for more
	information
X-VGTU-MailScanner-OpenProtect: Found to be clean
X-MailScanner-OpenProtect-MCPCheck: 
X-MailScanner-OpenProtect-From: nso@fmf.vtu.lt
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.262 required=5 tests=[AWL=-0.112,
	DNS_FROM_RFC_ABUSE=0.374]
X-Spam-Level: 
X-Archive-Number: 200510/238
X-Sequence-Number: 15006

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.