On Thu, 22 Mar 2007 13:18:12 -0300
Jorge Godoy <[EMAIL PROTECTED]> wrote:
> >
> > [EMAIL PROTECTED] tmp]$ psql -p 54382
> > Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL interactive terminal.
> > (snip)
>
> ... is 8.*1*.2, not 8.*2*.
No. This is "Server 8.2.3" , so I connect to 8.2.3 ser
>
>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
TANIDA Yutaka <[EMAIL PROTECTED]> writes:
> My customer found a problem about PL/pgsql functions and TRUNCATE command.
> If you execute PL/pgsql function includeing TRUNCATE command concurrently,
> causes "relation ... does not exist." or "relation with OID X does not
> exist" against
> exist
>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
TANIDA Yutaka <[EMAIL PROTECTED]> writes:
> If you execute PL/pgsql function includeing TRUNCATE command concurrently,
> causes "relation ... does not exist." or "relation with OID X does not
> exist" against
> exists table.
Do you still see this in 8.2?
regards, tom
Hi,
On Thu, 22 Mar 2007 07:48:18 +
Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> Can you reproduce this with 8.2?
Yes, I can.
[EMAIL PROTECTED] tmp]$ psql -p 54382
Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL interactive terminal.
(snip)
tanida=# \q
[EMAIL PROTECTED] tmp]$ pgbenc
>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
