Re: Compressed binary field

Edson Richter  wrote:
> Em 12/09/2012 00:37, Edson Richter escreveu:
>> Em 11/09/2012 14:59, Kevin Grittner escreveu:
>>> Edson Richter  wrote:

>>>> [biggest relation was a table heap with 29321 pages]

>>>> [block size is 8 KB]

>>> So your biggest table is actually 229 MB. Something is not adding
>>> up. I can't see any way to reconcile your previous statements
>>> with this number. There also hasn't been any real explanation for
>>> the statement that you have 250000 files. There must be something
>>> which matters here which hasn't yet been mentioned. Any ideas?

>> I don't know why, look result of the following query (arquivo is
>> the bytea field):
>>
>> select count(*) from notafiscalarq where arquivo is not null;
>> count
>> --------
>> 715084

What is a count of active rows in that table supposed to show me?

> Look at the size (5100MB) of this table alone (got after Vacuum
> with PgAdmin 14):

Please show (copy/paste if possible) *exactly* how you arrived at
that number and *exactly* how you determined that this number
represented the size of a table and how you determined which table.
If the results you previously posted are from the same database, you
simply don't have a table heap that large.

-Kevin