Estimados.
Espero que tenga un buen día, les escribo porque tengo un problema
extraño, estoy insertando en una tabla de 5 columnas (bigint,
timestamp, varchar, varchar, xml) una fila cuyo campo xml pesa entre
800MiB a 1.2GiB, sin embargo el INSERT de una única fila, se cae por
memoria (he probado en un equipo con 4GiB de RAM, otro con 6GiB y un
servidor con 8GiB, en todo se cae por memoria).
Mirando el log me arroja lo que adjunto. El ulimit del sistema está en
unlimited.
No he podido comprender el problema, el sistema ocupa gran parte de la
memoria RAM, pero nada de la swap, los parámetros de postgresql.conf
que estoy usando son:
shared_buffers = 1024MB
work_mem = 128MB
maintenance_work_mem = 256MB
wal_buffers = 1MB
effective_cache_size = 2048MB
Saludos cordiales.
2011-09-22 15:36:46 CLST WARNING: uso no estandar de escape en un literal de
cadena en carácter 73
2011-09-22 15:36:46 CLST HINT: Use la sintaxis de escape para cadenas, por ej.
E'\r\n'.
TopMemoryContext: 49416 total in 6 blocks; 8960 free (13 chunks); 40456 used
TopTransactionContext: 8192 total in 1 blocks; 7792 free (0 chunks); 400 used
MessageContext: 1991443800 total in 4 blocks; 7728 free (2 chunks);
1991436072 used
Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used
smgr relation table: 8192 total in 1 blocks; 2816 free (0 chunks); 5376 used
TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16
used
Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
PortalMemory: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 8192 total in 1 blocks; 3376 free (0 chunks); 4816 used
CacheMemoryContext: 667696 total in 20 blocks; 211496 free (0 chunks); 456200
used
pg_user_mapping_user_server_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_user_mapping_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_type_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_type_typname_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_ts_template_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_template_tmplname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_parser_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_parser_prsname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_dict_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_ts_dict_dictname_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_ts_config_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_config_cfgname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_config_map_index: 1024 total in 1 blocks; 192 free (0 chunks); 832
used
pg_statistic_relid_att_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_class_relname_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_proc_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 192 free (0
chunks); 832 used
pg_opfamily_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_opfamily_am_name_nsp_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 128 free (0
chunks); 896 used
pg_namespace_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_namespace_nspname_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_language_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_language_name_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_foreign_server_oid_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_foreign_server_name_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_foreign_data_wrapper_oid_index: 1024 total in 1 blocks; 344 free (0
chunks); 680 used
pg_foreign_data_wrapper_name_index: 1024 total in 1 blocks; 344 free (0
chunks); 680 used
pg_enum_typid_label_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_enum_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_database_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_conversion_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_constraint_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_conversion_name_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_conversion_default_index: 1024 total in 1 blocks; 128 free (0 chunks);
896 used
pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_cast_source_target_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_authid_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_authid_rolname_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_auth_members_role_member_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_amop_opr_fam_index: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_operator_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_amproc_fam_proc_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
pg_amop_fam_strat_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
pg_opclass_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_class_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
MdSmgr: 8192 total in 1 blocks; 7816 free (0 chunks); 376 used
LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
Timezones: 78520 total in 2 blocks; 5968 free (0 chunks); 72552 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
TopMemoryContext: 49416 total in 6 blocks; 8960 free (13 chunks); 40456 used
TopTransactionContext: 8192 total in 1 blocks; 7792 free (0 chunks); 400 used
MessageContext: 1991443800 total in 4 blocks; 7728 free (2 chunks);
1991436072 used
Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used
smgr relation table: 8192 total in 1 blocks; 2816 free (0 chunks); 5376 used
TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16
used
Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
PortalMemory: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 8192 total in 1 blocks; 3376 free (0 chunks); 4816 used
CacheMemoryContext: 667696 total in 20 blocks; 211496 free (0 chunks); 456200
used
pg_user_mapping_user_server_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_user_mapping_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_type_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_type_typname_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_ts_template_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_template_tmplname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_parser_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_parser_prsname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_dict_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_ts_dict_dictname_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_ts_config_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_config_cfgname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_config_map_index: 1024 total in 1 blocks; 192 free (0 chunks); 832
used
pg_statistic_relid_att_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_class_relname_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_proc_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 192 free (0
chunks); 832 used
pg_opfamily_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_opfamily_am_name_nsp_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 128 free (0
chunks); 896 used
pg_namespace_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_namespace_nspname_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_language_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_language_name_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_foreign_server_oid_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_foreign_server_name_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_foreign_data_wrapper_oid_index: 1024 total in 1 blocks; 344 free (0
chunks); 680 used
pg_foreign_data_wrapper_name_index: 1024 total in 1 blocks; 344 free (0
chunks); 680 used
pg_enum_typid_label_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_enum_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_database_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_conversion_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_constraint_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_conversion_name_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_conversion_default_index: 1024 total in 1 blocks; 128 free (0 chunks);
896 used
pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_cast_source_target_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_authid_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_authid_rolname_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_auth_members_role_member_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_amop_opr_fam_index: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_operator_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_amproc_fam_proc_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
pg_amop_fam_strat_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
pg_opclass_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_class_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
MdSmgr: 8192 total in 1 blocks; 7816 free (0 chunks); 376 used
LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
Timezones: 78520 total in 2 blocks; 5968 free (0 chunks); 72552 used
ErrorContext: 33570840 total in 3 blocks; 16256 free (10 chunks); 33554584
used
TopMemoryContext: 49416 total in 6 blocks; 8960 free (13 chunks); 40456 used
TopTransactionContext: 8192 total in 1 blocks; 7792 free (0 chunks); 400 used
MessageContext: 1991443800 total in 4 blocks; 7728 free (2 chunks);
1991436072 used
Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used
smgr relation table: 8192 total in 1 blocks; 2816 free (0 chunks); 5376 used
TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16
used
Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
PortalMemory: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 8192 total in 1 blocks; 3376 free (0 chunks); 4816 used
CacheMemoryContext: 667696 total in 20 blocks; 211496 free (0 chunks); 456200
used
pg_user_mapping_user_server_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_user_mapping_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_type_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_type_typname_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_ts_template_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_template_tmplname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_parser_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_parser_prsname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_dict_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_ts_dict_dictname_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_ts_config_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_ts_config_cfgname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_ts_config_map_index: 1024 total in 1 blocks; 192 free (0 chunks); 832
used
pg_statistic_relid_att_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_class_relname_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_proc_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 192 free (0
chunks); 832 used
pg_opfamily_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_opfamily_am_name_nsp_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 128 free (0
chunks); 896 used
pg_namespace_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_namespace_nspname_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_language_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_language_name_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_foreign_server_oid_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_foreign_server_name_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_foreign_data_wrapper_oid_index: 1024 total in 1 blocks; 344 free (0
chunks); 680 used
pg_foreign_data_wrapper_name_index: 1024 total in 1 blocks; 344 free (0
chunks); 680 used
pg_enum_typid_label_index: 1024 total in 1 blocks; 280 free (0 chunks); 744
used
pg_enum_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_database_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_conversion_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_constraint_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_conversion_name_nsp_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_conversion_default_index: 1024 total in 1 blocks; 128 free (0 chunks);
896 used
pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_cast_source_target_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_authid_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_authid_rolname_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_auth_members_role_member_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 280 free (0
chunks); 744 used
pg_amop_opr_fam_index: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_operator_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_amproc_fam_proc_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
pg_amop_fam_strat_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
pg_opclass_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_class_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
MdSmgr: 8192 total in 1 blocks; 7816 free (0 chunks); 376 used
LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
Timezones: 78520 total in 2 blocks; 5968 free (0 chunks); 72552 used
ErrorContext: 33570840 total in 3 blocks; 16256 free (10 chunks); 33554584
used
2011-09-22 15:36:58 CLST ERROR: out of memory
2011-09-22 15:36:58 CLST DETAIL: Failed on request of size 67108864.-
Enviado a la lista de correo pgsql-es-ayuda ([email protected])
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda
