From: NSO <nso@fmf.vtu.lt>
To: pgsql-performance@postgresql.org
Subject: Bytea poor performance
Date: Sat, 15 Oct 2005 16:20:54 +0300 (EEST)
Message-ID: <17260.81.7.89.65.1129382454.squirrel@fmf.vtu.lt> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nso@fmf.vtu.lt
Subject: Re: Bytea poor performance
In-Reply-To: <17260.81.7.89.65.1129382454.squirrel@fmf.vtu.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox