>
>No,
>actually I haven't yet.
>I have noticed that during the time
the query
>executes there is neither so much CPU load nor network
(communication
>with db) load. The client seems to hang, then after a
minute or so the
>query returns data.
>I also thought this problem
could be related to
>
>Well, that eliminates the theory that you've got a lot of dead
tuples
>slowing it down. I come back to the conclusion that it's
probably a
>client-side problem. Have you tried watching with "top" or
similar tool
>to check which process is eating all the time?
>
No,
actually I haven't yet
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
>> Hmm ... what does VACUUM VERBOSE of that table show?
> Here is the
> output of VACUUM VERBOSE
Well, that eliminates the theory that you've got a lot of dead tuples
slowing it down. I come back to the conclusion that it's probably a
client-side
>Hmm ... what does VACUUM VERBOSE of that table show?
>
Here is the
output of VACUUM VERBOSE
INFO: vacuuming "public.FILE"
INFO: scanned
index "FILE_pkey" to remove 54 row versions
DETAIL: CPU 0.00s/0.00u
sec elapsed 0.01 sec.
INFO: "FILE": removed 54 row versions in 5 pages
DETAIL: CPU 0
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
>> In psql the trick is to use unaligned display mode, else psql itself
>> eats a whole lot of time trying to nicely format those 250KB rows:
> Even using unaligned display mode (\a) it still takes more than 1
> minute
Hmm ... what does VACUUM VERB
>In psql the trick is to use unaligned display mode, else psql itself
>eats a whole lot of time trying to nicely format those 250KB rows:
Even using unaligned display mode (\a) it still takes more than 1
minute
>
>I surmise that your problem is likewise on the client side,
but you
>weren't ve
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> The test table has 36 records and each bytea field
> contains a 250KB object. A (SELECT byteafield FROM table) takes more
> than 1 minute to execute.
Hm, it takes about 4 seconds here, on a fairly old and slow machine:
$ time psql -A -c "select
