Re: Bloated Table
От | Brad Nicholson |
---|---|
Тема | Re: Bloated Table |
Дата | |
Msg-id | 1243442284.20786.15.camel@bnicholson-desktop обсуждение исходный текст |
Ответ на | Re: Bloated Table (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Bloated Table
|
Список | pgsql-general |
On Wed, 2009-05-27 at 11:15 -0400, Tom Lane wrote: > =?iso-8859-1?Q?Alexander_Sch=F6cke?= <asc@turtle-entertainment.de> writes: > > I'm using a view > > (http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html) to > > display the bloat (unused disk space) of the tables in a PostgreSQL > > database. > > I wouldn't trust the calculations that view does in the least. > You might look at contrib/pgstattuple if you want numbers that > have some relationship to reality (and are correspondingly more > expensive to get :-() > > regards, tom lane Is the referenced query reliable for even estimating, or is it flat our wrong? Co-workers that were PGCon are saying that this is becoming a popular/accepted way to check for bloated tables. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
В списке pgsql-general по дате отправления: