From: | "John Hansen" <john(at)geeknet(dot)com(dot)au> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: max_fsm_pages >800k ... ? |
Date: | 2005-06-15 18:18:50 |
Message-ID: | 5066E5A966339E42AA04BA10BA706AE50A934D@rodrick.geeknet.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
INFO: analyzing "pg_catalog.pg_depend"
INFO: "pg_depend": 27 pages, 3866 rows sampled, 3866 estimated total
rows
INFO: free space map: 423 relations, 88475 pages stored; 431200 total
pages needed
DETAIL: Allocated FSM size: 4000 relations + 80000 pages = 705 kB
shared memory.
This, on a database with a moderate amount of rows (<10 Million)
So,.. I'd say fairly normal.
... John
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Marc
> G. Fournier
> Sent: Thursday, June 16, 2005 3:57 AM
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: [HACKERS] max_fsm_pages >800k ... ?
>
>
> Without more information to provide at this time, does the
> following seem "unusual"?
>
> INFO: free space map: 252 relations, 411494 pages stored;
> 738640 total pages needed
> DETAIL: Allocated FSM size: 2000 relations + 400000 pages =
> 2463 kB shared memory.
>
> I know there are alot of factors involved in the above, which
> I'm looking into, but when I first saw the above, I just
> about had a heartattack, only because i've never seen such
> high #s for total pages needed ...
>
> ... Is this something that others are seeing as relatively normal?
>
>
>
>
> ----
> Marc G. Fournier Hub.Org Networking Services
> (http://www.hub.org)
> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy
> ICQ: 7615664
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2005-06-15 18:32:32 | Re: Add PG version number to NLS files |
Previous Message | Stefan Kaltenbrunner | 2005-06-15 18:08:32 | Re: Gist Recovery testing |