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