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 +-