On 2/23/07, msmbarabino@xxxxxxxxxxx <msmbarabino@xxxxxxxxxxx> wrote:
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
are you getting the data from the local box or from a remote site? also explain analyze is showing nothing slow but you did not post the enitre output. also, try the \timing switch in psql. merlin
