|
8 | 8 | * Portions Copyright (c) 1994, Regents of the University of California |
9 | 9 | * |
10 | 10 | * IDENTIFICATION |
11 | | - * $PostgreSQL: pgsql/src/backend/storage/freespace/freespace.c,v 1.37 2004/12/31 22:00:54 pgsql Exp $ |
| 11 | + * $PostgreSQL: pgsql/src/backend/storage/freespace/freespace.c,v 1.38 2005/03/12 05:21:52 momjian Exp $ |
12 | 12 | * |
13 | 13 | * |
14 | 14 | * NOTES: |
@@ -706,11 +706,25 @@ PrintFreeSpaceMapStatistics(int elevel) |
706 | 706 | needed= (sumRequests+numRels)*CHUNKPAGES; |
707 | 707 |
|
708 | 708 | ereport(elevel, |
709 | | -(errmsg("free space map: %d relations, %d pages stored; %.0f total pagesneeded", |
| 709 | +(errmsg("free space map: %d relations, %d pages stored; %.0f total pagesused", |
710 | 710 | numRels,storedPages,needed), |
711 | | -errdetail("AllocatedFSM size: %d relations + %d pages = %.0f kB shared memory.", |
| 711 | +errdetail("FSM size: %d relations + %d pages = %.0f kB shared memory.", |
712 | 712 | MaxFSMRelations,MaxFSMPages, |
713 | 713 | (double)FreeSpaceShmemSize() /1024.0))); |
| 714 | + |
| 715 | +if (numRels==MaxFSMRelations) |
| 716 | +ereport(NOTICE, |
| 717 | +(errmsg("max_fsm_relations(%d) equals the number of relations checked", |
| 718 | +MaxFSMRelations), |
| 719 | +errhint("You have >= %d relations.\n" |
| 720 | +"Consider increasing the configuration parameter \"max_fsm_relations\".", |
| 721 | +numRels))); |
| 722 | +elseif (needed>MaxFSMPages) |
| 723 | +ereport(NOTICE, |
| 724 | +(errmsg("the number of page slots needed (%.0f) exceeds max_fsm_pages (%d)", |
| 725 | +needed,MaxFSMPages), |
| 726 | +errhint("Consider increasing the configuration parameter \"max_fsm_relations\"\n" |
| 727 | +"to a value over %.0f.",needed))); |
714 | 728 | } |
715 | 729 |
|
716 | 730 | /* |
|