Good one. Unfortunately it doesn't show anything weird either. Using any of these two scripts: http://wiki.postgresql.org/wiki/Show_database_bloat http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html I can only see about 90MB Thanks 2013/12/10 Ian Lawrence Barwick <barwick@xxxxxxxxx>: > 2013/12/10 Luis <luisico@xxxxxxxxx>: >> Thanks Ian, >> >> Actually the query I used to get the relations sizes also included >> indexes and even pg_toast. > > Doh, sorry I didn't notice there was no relkind qualification on pg_class > in your query. > >> This query gives me more detail about the >> indexes related to every table but still can't see where the space is. > > Table/index bloat? > > > Ian Barwick -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
