136 reputation
4
bio website
location Saskatoon, Canada
age
visits member for 3 years, 11 months
seen Jul 14 at 19:25

I write custom Java/C++ applications for clients in the global satellite telecommunication industry.


May
25
awarded  Popular Question
Aug
28
awarded  Supporter
Aug
13
comment Postmaster uses excessive CPU and Disk Writes
I'll have to ask my in-house expert on whether we tried adjusting the temp_buffers value or not (we tried a lot of different things). The question you point to doesn't really apply as we're not using temporary tables in that way. I've updated the question with some more details.
Aug
13
revised Postmaster uses excessive CPU and Disk Writes
added 1240 characters in body
Aug
13
comment Postmaster uses excessive CPU and Disk Writes
I've put the postgresql.conf file here. I believe you cannot create a table that is both temporary AND unlogged. There are 6 1TB disks in a RAID 1+0 (3TB total storage)
Aug
13
comment Postmaster uses excessive CPU and Disk Writes
@vezult this happens pretty much as long as my application software is running (which establishes a number of long-lived connections). Yes, there are triggers on all the tables that are being inserted into.
Aug
13
comment Postmaster uses excessive CPU and Disk Writes
@voretaq7 yes, we had serious performance problems. We did some timing measurements at the system level of a common action before and after we removed the temporary tables. Replacing the temporary tables with 'regular' tables reduced the times by 2 orders of magnitude (100x).
Jul
13
revised Postmaster uses excessive CPU and Disk Writes
added 463 characters in body
Jul
4
comment Postmaster uses excessive CPU and Disk Writes
@womble, I have updated the question with output from strace.
Jul
4
comment Postmaster uses excessive CPU and Disk Writes
@MilenA.Radev, so it looks like I might be doing something weird/excessive with temporary tables. This is interesting. I do have a lot of triggers in place that do make use of temporary tables. I will look closer at these.
Jul
4
revised Postmaster uses excessive CPU and Disk Writes
added 1290 characters in body
Jul
4
awarded  Student
Jul
3
awarded  Editor
Jul
3
revised Postmaster uses excessive CPU and Disk Writes
added 1111 characters in body
Jul
3
asked Postmaster uses excessive CPU and Disk Writes