| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | salah jubeh <s_jubeh(at)yahoo(dot)com> |
| Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: bloating index, pg_restore |
| Date: | 2013-03-28 03:49:23 |
| Message-ID: | CAL_0b1uoPduFXUM2jUsU+PCnxN-59695Uk3gkXLY=9xYzeismg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
On Wed, Mar 27, 2013 at 9:56 AM, salah jubeh <s_jubeh(at)yahoo(dot)com> wrote:
> I have a database which is bloated because of vacuum full, so you find
> indexes bigger than the table itself.
Table can not be bloated because of vacuum full, it removes bloat from
the table and its indexes. The fact that an index is larger then the
table it it built on does not say that something is bloated. Use the
pgstattuple extension to determine bloat
http://www.postgresql.org/docs/9.2/static/pgstattuple.html.
> I have dumped this database and restored it without reindixing and it was
> extremely slow. So, my question what is the relation between bloated
> database and pg_restore.
>
> Regards
--
Kind regards,
Sergey Konoplev
Database and Software Consultant
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-03-28 04:08:19 | Re: bloating index, pg_restore |
| Previous Message | David Johnston | 2013-03-27 23:48:14 | Re: Money casting too liberal? |