REINDEX not working for wastedspace
От | AI Rumman |
---|---|
Тема | REINDEX not working for wastedspace |
Дата | |
Msg-id | CAGoODpcBxGLyF=bY3_5opO4YckgJqFGwBxveU_cYsrXBbN4NgQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: REINDEX not working for wastedspace
Re: REINDEX not working for wastedspace Re: REINDEX not working for wastedspace Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace] Re: REINDEX not working for wastedspace |
Список | pgsql-performance |
I am using Postgresql 9.0.1.
Using the query http://wiki.postgresql.org/wiki/Show_database_bloat, I got the following result for a table:
-[ RECORD 1 ]----+-----------------------------------------------
current_database | crm
schemaname | public
tablename | _attachments
tbloat | 0.9
wastedbytes | 0
iname | attachments_description_type_attachmentsid_idx
ibloat | 2.3
wastedibytes | 5439488
-[ RECORD 2 ]----+-----------------------------------------------
current_database | crm
schemaname | public
tablename | _attachments
tbloat | 0.9
wastedbytes | 0
iname | attachments_attachmentsid_idx
ibloat | 0.2
wastedibytes | 0
-[ RECORD 3 ]----+-----------------------------------------------
current_database | crm
schemaname | public
tablename | _attachments
tbloat | 0.9
wastedbytes | 0
iname | _attachments_pkey
ibloat | 0.2
wastedibytes | 0
I REINDEXED both the indexes and table, but I did not find any change in wastedspace or wastedispace.
Could you please tell me why?
Using the query http://wiki.postgresql.org/wiki/Show_database_bloat, I got the following result for a table:
-[ RECORD 1 ]----+-----------------------------------------------
current_database | crm
schemaname | public
tablename | _attachments
tbloat | 0.9
wastedbytes | 0
iname | attachments_description_type_attachmentsid_idx
ibloat | 2.3
wastedibytes | 5439488
-[ RECORD 2 ]----+-----------------------------------------------
current_database | crm
schemaname | public
tablename | _attachments
tbloat | 0.9
wastedbytes | 0
iname | attachments_attachmentsid_idx
ibloat | 0.2
wastedibytes | 0
-[ RECORD 3 ]----+-----------------------------------------------
current_database | crm
schemaname | public
tablename | _attachments
tbloat | 0.9
wastedbytes | 0
iname | _attachments_pkey
ibloat | 0.2
wastedibytes | 0
I REINDEXED both the indexes and table, but I did not find any change in wastedspace or wastedispace.
Could you please tell me why?
В списке pgsql-performance по дате отправления: