André Volpato wrote: > É apenas uma maneira de provar que ele reduz espaço. > euler=# select relname,pg_catalog.pg_relation_size(oid) from pg_class where relname ~ 'foo'; relname | pg_relation_size ----------+------------------ foo | 1613824 foo_pkey | 3596288 (2 registros)
euler=# reindex table foo; REINDEX euler=# select relname,pg_catalog.pg_relation_size(oid) from pg_class where relname ~ 'foo'; relname | pg_relation_size ----------+------------------ foo_pkey | 917504 foo | 1613824 (2 registros) -- Euler Taveira de Oliveira http://www.timbira.com/ _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
