1) собрать все логи с бд по локам 2) made a with query enclosing every row with ‘ and with ; at the end —-best of all do this on different server Result is: as you can see the PID 10219 is the cause of cascade locks 4) also you can check what that PID … Читать далее
to be continued > — what does «Bitmap Heap Scan» phase do? A plain indexscan fetches one tuple-pointer at a time from the index, and immediately visits that tuple in the table. A bitmap scan fetches all the tuple-pointers from the index in one go, sorts them using an in-memory «bitmap» data structure, and then … Читать далее
helps to keep focus on «hot» tables top 10 tables by sum of io operatoins: top 10 tables by index scans:
For better result you should install database by this document how-to install postgres database i have 4 node config, 2 nodes in one datacenter and 2 in other config will look like this: create config file: node1 /u01/postgres/9.5/main/conf/repmgr.conf node2 /u01/postgres/9.5/main/conf/repmgr.conf node3 /u01/postgres/9.5/main/conf/repmgr.conf node4 /u01/postgres/9.5/main/conf/repmgr.conf also we need to setup passwordless auth of repmgr user create … Читать далее
I will split material of how-to install pgpool on several logical parts here is the first one: start install postgres with packages: for 9.6 for 10 create directories and change home directory of postgres user: configure bash_profile: create dummy database: configure init scripts ( or systemd daemon ) to work with our external config directory: … Читать далее
here is my drafts of how-to automate upload a lot of csv files to database ( use text fieds because there is no need to mach all types of columns in this case )
sample output also usefull to look at usage stat on this indexes