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

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