News for hackers. Stuff that matters.
Re:Leaving MySQL by Izkata on Monday December 06, 2021 @01:35AM (#29456860)
IIRC it's because some of the default settings were chosen back when RAM was measured in MB and low GB and not really updated. work_mem, for example, can typically be safely set to several times its default of 4MB, which then allows individual operations to use more memory before spilling over into temporary files on disk.

Of course, that particular example really only matters if you're actually hitting the 4MB limit in your queries, but I think there were some other settings with similar too-low defaults.

There are no comments on this comment yet.