[PERFORM] Occasional Slow Commit

Hi, I've got an OLTP application which occasionally suffers from slow commit time. The process in question does something like this: 1. Do work 2. begin transaction 3. insert record 4. commit transaction 5. Do more work 6. begin transaction 7. update record 8. commit transaction 9. Do more work

[PERFORM] maintenance_work_mem and create index

Hello, I have a question regarding the maintenance_work_mem and the index creation. I have a dedicated postgresql server with 16GB of RAM. The shared_buffers is 4GB and the maintenance_work_mem is 2GB. I have a table with 28 mil records and 2 one-column indexes: 1. First index is for an inte