Hi! On Sun, Jan 6, 2019 at 11:01 AM Mitar <mmi...@gmail.com> wrote: > I have experimented a bit and performance really improves if /dev/shm > is used. I have experimented with creating temporary tables inside a > regular (SSD backed) tablespace /dev/shm and I have seen at least 2x > improvement in time it takes for a set of modification+select queries > to complete.
I also tried just to increase temp_buffers to half the memory, and things are better, but not to the same degree as using a /dev/shm tablespace. Why is that? (All my temporary objects in my experiments are small, few 10k rows, few MBs.) Mitar -- http://mitar.tnode.com/ https://twitter.com/mitar_m
