Posts

Showing posts from January, 2018

AWS Aurora Postgres, not a great first impression

Image
Recently we had a customer facing some memory issues with an Aurora PostgreSQL. What was happening is that while loading data or creating GiST indexes they got the following error :


2018-01-0414:03:06UTC:171.32.45.250(35508):root@test:[20457]:ERROR:outofmemory2018-01-0414:03:06UTC:171.32.45.250(35508):root@test:[20457]:DETAIL:Failedonrequestofsize23.2018-01-0414:03:06UTC:171.32.45.250(35508):root@test:[20457]:STATEMENT:INSERTINTOtest_table1VALUES('domain1.com','Manual','[198.168.1.148,198.168.1.250]','t','f','2016-02-16 15:58:58.016626','',''),('domain2.com','Manual','[192.168.1.1,192.168.1.174]','t','f','2016-02-16 15:58:58.023136','',''),...
At the same time they had a major drop in freeable memory :



logs showed that :

TopMemoryContext:1184792totalin13blocks;14024free(5chunks);1170768usedCFuncHash:8192totalin1blocks;776free(0chunks);7416usedTypeinformationcache…