Re: [GENERAL] [PERFORM] Questionaire: Common WAL write rates on busy servers.

On Tue, Apr 25, 2017 at 1:17 AM, Andres Freund wrote: > Questions (answer as many you can comfortably answer): > - How many MB/s, segments/s do you see on busier servers? ~20MB/s with FPW compression, with peaks of ~35MB/s. Writes become the bottleneck without compression and

Re: [PERFORM] [GENERAL] DELETE taking too much memory

On Fri, Jul 8, 2011 at 12:48 PM, Dean Rasheed dean.a.rash...@gmail.com wrote: Yes, it's the same issue that affects deferrable PK and FK constraints, but even non-deferrable FKs use AFTER ROW triggers that suffer from this problem. These triggers don't show up in a \d from psql, but they are