On 2/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
