Timeline for How to get rid of BufferMapping?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 13, 2023 at 16:34 | comment | added | jjanes | 2nd block is the one containing "LWLock BufferMapping create_temp_users(0)" | |
| Jan 13, 2023 at 11:20 | comment | added | lampa | @jjanes hi, I'm bad at administration, but i see, that /pgdata stored on 64 lvm and I did not notice any problems with io. Its a steady state problem. Length of locks in seconds or in what dimension? When i run procedure once, i see 15seconds, when i run parallel 200 threads, i see ~ 8 minutes. And i not understand what is "2nd block". | |
| Jan 13, 2023 at 11:01 | comment | added | jjanes | How long are the long LW locks? Please quantify. Is each individual one long, or only long on aggregate? | |
| Jan 13, 2023 at 10:59 | comment | added | jjanes | What is your IO subsystem spec? Is this a steady state problem, or just a cold start problem? Where is that 2nd block from? That format is not obviously recognizable to me. | |
| Jan 13, 2023 at 9:43 | answer | added | Laurenz Albe | timeline score: 1 | |
| S Jan 13, 2023 at 7:36 | review | First questions | |||
| Jan 13, 2023 at 8:04 | |||||
| S Jan 13, 2023 at 7:36 | history | asked | lampa | CC BY-SA 4.0 |