Postgres Pro
Downloads
Home   >   mailing lists

Re: Very slow bytea extraction - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Very slow bytea extraction
Date
Msg-id 3585.1174577206@sss.pgh.pa.us
Whole thread Raw
In response to Re: Very slow bytea extraction  ("msmbarabino@virgilio.it" <msmbarabino@virgilio.it>)
List pgsql-bugs
Tree view 
"msmbarabino@virgilio.it" <msmbarabino@virgilio.it> 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 VERBOSE of that table show?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Relation not found" error but table exits.
Next
From: "msmbarabino@virgilio.it"
Date:
Subject: Re: Very slow bytea extraction