Skip to content
Jack Gao edited this page Mar 5, 2017 · 2 revisions

Work is done.

postgres=# create extension pg_memorycontext;
CREATE EXTENSION
postgres=# select * from pg_memorycontext;
            memorycontextname            | count | totalsize 
-----------------------------------------+-------+-----------
 CacheMemoryContext                      |     1 |    516096
 Timezones                               |     1 |    104120
 TopMemoryContext                        |     1 |     95880
 MessageContext                          |     1 |     65536
 WAL record construction                 |     1 |     49768
 TupleSort main                          |     1 |     32824
 TransactionAbortContext                 |     1 |     32768
 Relcache by OID                         |     1 |     24576
 ExecutorState                           |     1 |     24576
 smgr relation table                     |     1 |     24576
 pg_memorycontext hash table             |     1 |     24576
 Record information cache                |     1 |     24576
 CFuncHash                               |     1 |      8192
 PrivateRefCount                         |     1 |      8192
 TopTransactionContext                   |     1 |      8192
 ErrorContext                            |     1 |      8192
 Portal hash                             |     1 |      8192
 PortalMemory                            |     1 |      8192
 Operator class cache                    |     1 |      8192
 LOCALLOCK hash                          |     1 |      8192
 MdSmgr                                  |     1 |      8192
 pg_memorycontext                        |     1 |      7168
 pg_opfamily_am_name_nsp_index           |     1 |      3072
 pg_default_acl_role_nsp_obj_index       |     1 |      3072
 pg_ts_config_map_index                  |     1 |      3072
 pg_proc_proname_args_nsp_index          |     1 |      3072
 pg_collation_name_enc_nsp_index         |     1 |      3072
 pg_opclass_am_name_nsp_index            |     1 |      3072
 pg_amop_opr_fam_index                   |     1 |      3072
 pg_shseclabel_object_index              |     1 |      3072
 pg_amproc_fam_proc_index                |     1 |      3072
 pg_amop_fam_strat_index                 |     1 |      3072
 pg_conversion_default_index             |     1 |      3072
 pg_statistic_relid_att_inh_index        |     1 |      3072
 pg_operator_oprname_l_r_n_index         |     1 |      3072
 pg_opclass_oid_index                    |     1 |      1024
 pg_authid_rolname_index                 |     1 |      1024
 pg_transform_type_lang_index            |     1 |      1024
 pg_auth_members_role_member_index       |     1 |      1024
 pg_ts_dict_dictname_index               |     1 |      1024
 pg_opfamily_oid_index                   |     1 |      1024
Clone this wiki locally