Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: vacuum verbose relations reporting
- From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
- To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: vacuum verbose relations reporting
- Date: Sun, 31 Aug 2008 09:46:32 -0700 (PDT)
- Message-id: <Pine.LNX.4.64.0808310941020.4517@discord.home.frostconsultingllc.com> <text/plain>
On Sun, 31 Aug 2008, Alvaro Herrera wrote:
Jeff Frost wrote:I guess this isn't entirely accurate, as the above script returns 35883, but vacuum verbose returns: INFO: free space map contains 111435 pages in 10005 relationsWell, what this means is that not every single table has useful free space ...
Ohh...naturally. So, max_fsm_relations only cares about relations that have free space to track, and not all relations. So, is there a way to compute the number of relatinos with useful free space?
-- Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 916-647-6411 FAX: 916-405-4032
- References:
- vacuum verbose relations reporting
- From: Jeff Frost
- Re: vacuum verbose relations reporting
- From: Carol Walter
- Re: vacuum verbose relations reporting
- From: Jeff Frost
- Re: vacuum verbose relations reporting
- From: Tom Lane
- Re: vacuum verbose relations reporting
- From: Jeff Frost
- Re: vacuum verbose relations reporting
- From: Alvaro Herrera
- Re: vacuum verbose relations reporting
- From: Jeff Frost
- Re: vacuum verbose relations reporting
- From: Jeff Frost
- Re: vacuum verbose relations reporting
- From: Alvaro Herrera
- vacuum verbose relations reporting
- Prev by Date: Re: vacuum verbose relations reporting
- Previous by thread: Re: vacuum verbose relations reporting
- Next by thread: 32 to 64 bit change over
- Indexes: