R: Very slow bytea data extraction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks for your reply,


>Is it in executing the query (what does 
EXPLAIN ANALYSE show)?

Here is the output of explain analyze SELECT * 
FROM "FILE"

"Seq Scan on "FILE"  (cost=0.00..1.36 rows=36 width=235) 
(actual time=0.023..0.107 rows=36 loops=1)"


>How are you accessing 
the database: odbc,jdbc,other?
>Does it do this with psql too?

The 
problem is the same when I access the db with jdbc, pgAdmin and even 
psql


Massimo



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux