After upgrading our database from 9.3.5 to 9.4.1 last night, the server suffers from high CPU spikes. The upgrade was done with pg_dump. So the database was converted to SQL and then imported into 9.4.
During the CPU spikes, there are a lot of these messages in the logs:
process X still waiting for ExclusiveLock on extension of relation Y of database Z after 1036.234 ms
process X acquired ExclusiveLock on extension of relation Y of database Z after 2788.050 ms
What looks suspicious is that there are sometimes several "acquired" messages for the exact same relation number in the exact same millisecond.
Why would Postgres grow a table twice in the same millisecond? Could it be an index with a high fill factor?
Any suggestions on how to approach this issue are welcome.
P.S. I've also asked this question on the Postgres mailing list, if that's not okay let me know.