Hi!
On Sun, Jan 6, 2019 at 11:01 AM Mitar <mmitar(at)gmail(dot)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