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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
