Re: db size

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Bill Moran <wmoran(at)collaborativefusion(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: db size
Date: 2008-04-17 08:37:25
Message-ID: 48070C45.8010706@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

> You are tracking ~ 4.6 million pages and have space to track ~ 15.5
> million, so that's fine. You are right up against your limit of
> relations (tables, indexes etc) being tracked though - 1200. You'll
> probably want to increase max_fsm_relations - see manual for details
> (server configuration / free space map).

That is helpful, thanks.

I did a grep on the output to find out more about the max_fsm_relations:

INFO: free space map contains 2333562 pages in 832 relations
INFO: free space map contains 3012404 pages in 544 relations
INFO: free space map contains 3012303 pages in 654 relations
INFO: free space map contains 3012345 pages in 669 relations
INFO: free space map contains 3012394 pages in 678 relations
INFO: free space map contains 3017248 pages in 717 relations
INFO: free space map contains 2860737 pages in 824 relations
INFO: free space map contains 4667977 pages in 1199 relations
INFO: free space map contains 3140238 pages in 181 relations
INFO: free space map contains 3140322 pages in 182 relations
INFO: free space map contains 3140387 pages in 183 relations
INFO: free space map contains 3142781 pages in 184 relations

It doesn't go up close to 1200 often... should I still up that value?

--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

In response to

  • Re: db size at 2008-04-17 08:15:04 from Richard Huxton

Browse pgsql-performance by date

  From Date Subject
Next Message Adrian Moisey 2008-04-17 08:43:47 Re: db size
Previous Message Richard Huxton 2008-04-17 08:15:04 Re: db size