Em 11/09/2012 14:59, Kevin Grittner escreveu:
Edson Richter <edsonrichter@xxxxxxxxxxx> wrote:
Em 11/09/2012 14:34, Kevin Grittner escreveu:
Edson Richter <edsonrichter@xxxxxxxxxxx> wrote:
For storage, du -h --max-depth 1 on data directory gives me the
amount of data.
Biggest objects are just the tables with files.
I've 2 tables that held all these objects. Structure is
create table MYTABLE (id bigint not null primary key, mimetype
varchar(100) null, bytea datafile null)
Could you show the results of this query?:
SELECT relkind, oid, relfilenode, reltoastrelid,
relpages, reltuples
FROM pg_class
ORDER BY relpages DESC
LIMIT 10;
[biggest relation was a table heap with 29321 pages]
Also, just to be sure that all calculations are based on your
actual build, can you show the results of?:
SHOW block_size;
8192
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?
-Kevin
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
Strange, huh?
Edson.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
