Re: [PERFORM] table size is bigger than expected

2011-08-04 Thread Steve Crawford
On 08/04/2011 11:56 AM, Jian Shi wrote: Hey, I'm a new user of PostgreSQL. I found one of my tables is taking unexpectedly large space:... I did vaccum, reindex, the size is still the same. Is there anything else that I can do? Did you try CLUSTER? A basic vacuum only identifies space

Re: [PERFORM] table size is bigger than expected

2011-08-04 Thread Justin Pitts
On Thu, Aug 4, 2011 at 2:56 PM, Jian Shi wrote: > Hey, > >   I’m a new user of PostgreSQL. I found one of my tables is taking > unexpectedly large space: > > select > pg_size_pretty(pg_relation_size('archive_files')); > >  pg_size_pretty > > > > 1113 MB > > > the field “fname” sto

[PERFORM] table size is bigger than expected

2011-08-04 Thread Jian Shi
Hey, I'm a new user of PostgreSQL. I found one of my tables is taking unexpectedly large space: select pg_size_pretty(pg_relation_size('archive_files')); pg_size_pretty 1113 MB The structure of this table is like: Column | Type| Modifiers +-

Re: [PERFORM] Table Size

2007-01-16 Thread Guillaume Lelarge
Richard Huxton a écrit : > Gauri Kanekar wrote: >> Hi, >> >> Can anybody help me out to get following info of all the tables in a >> database. > > 1. Have you read up on the information schema and system catalogues? > http://www.postgresql.org/docs/8.2/static/catalogs.html > http://www.postgresql.

Re: [PERFORM] Table Size

2007-01-16 Thread Richard Huxton
Gauri Kanekar wrote: Hi, Can anybody help me out to get following info of all the tables in a database. 1. Have you read up on the information schema and system catalogues? http://www.postgresql.org/docs/8.2/static/catalogs.html http://www.postgresql.org/docs/8.2/static/catalogs.html table_

[PERFORM] Table Size

2007-01-16 Thread Gauri Kanekar
Hi, Can anybody help me out to get following info of all the tables in a database. table_len tuple_count tuple_len tuple_percent dead_tuple_count dead_tuple_len dead_tuple_percent free_space free_percent Thanks Gauri