>Monitoring software with also web access by many many users ~1 000 000
>They do something which need transaction and some select(reports) which "not need" transaction
>but in transactional database select also start short transaction then i can not remove it creation..

Maybe some of your selects can share read-only, read committed transactions? That would not block garbage collection so you don't have to commit it all too often. Though it does mean that the most recent record at the time of the read is read, so it might not be appropriate for your selects. And it will not be worth the effort if it only reduces the number of transactions from 18 million to 17,x million.

18 million transactions per day... That's an impressive number that is roughly 18 million transactions more per day than the number of transactions most of us work with.

Set