Skip site navigation (1) Skip section navigation (2)

Re: BUG #2236: extremely slow to get unescaped bytea data from db

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kai Ronan <support(at)kalador(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2236: extremely slow to get unescaped bytea data from db
Date: 2006-02-04 22:21:57
Message-ID: 20060204222156.GA24302@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
Kai Ronan wrote:

>  // Get the bytea data
>  $res = pg_query("SELECT data FROM image WHERE name='big.gif'");

Do you have an index in the image.name column?  What does an 

EXPLAIN ANALYZE SELECT data FROM image WHERE name='big.gif'

say?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-bugs by date

Next:From: Kalador Tech SupportDate: 2006-02-05 00:06:11
Subject: Re: BUG #2236: extremely slow to get unescaped bytea data
Previous:From: Bruno Wolff IIIDate: 2006-02-04 22:06:47
Subject: Re: BUG #2225: Backend crash -- BIG table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group