Re: Bytea poor performance

On 10/15/05 9:20 AM, "NSO" <nso(at)fmf(dot)vtu(dot)lt> 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 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..

How about some explain analyze output? Have you done a full vacuum lately?
How about reindexing?

Sean