Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding a concept of TEMPORARY TABLESPACE for the use in temp_tablespaces - Mailing list pgsql-hackers

From Mitar
Subject Re: Adding a concept of TEMPORARY TABLESPACE for the use in temp_tablespaces
Date
Msg-id CAKLmikMVafYSjkk=SRPxd9r=Q_N40QidZ9se15m5SB2CORnn7A@mail.gmail.com
Whole thread Raw
In response to Adding a concept of TEMPORARY TABLESPACE for the use in temp_tablespaces  (Mitar <mmitar@gmail.com>)
List pgsql-hackers
Tree view 
Hi!

On Sun, Jan 6, 2019 at 11:01 AM Mitar <mmitar@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

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: [PATCH] kNN for btree
Next
From: Tom Lane
Date:
Subject: Re: reducing the footprint of ScanKeyword (was Re: Large writable variables)