Edson Richter <[email protected]> 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; Also, just to be sure that all calculations are based on your actual build, can you show the results of?: SHOW block_size; Have you checked the level of bloat yet? (Perhaps autovacuum needs to be made more aggressive.) -Kevin
-- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
