| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Temporary tablespaces on a RAM disk |
| Date: | 2020-03-17 19:50:56 |
| Message-ID: | 920a66f7c939c5a59f50d62d4b3979e82c25ff21.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2020-03-17 at 09:49 +0000, Daniel Westermann (DWE) wrote:
> is someone using temporary tablespaces on a RAM disk ? Any experiences with that?
> I did some quick tests and checked the archives but could not find any information that either confirmed it is a bad idea nor the opposite.
Taking a step back, wouldn't it be better to increase "work_mem"
and "temp_buffers" and set "temp_file_limit", so that temporary
files are avoided whenever possible and temporary tables are cached?
Then essentially you are using the same memory for the same purposes,
but in a supported fashion.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Westermann (DWE) | 2020-03-17 19:51:10 | Re: Temporary tablespaces on a RAM disk |
| Previous Message | Tom Lane | 2020-03-17 19:41:09 | Re: Temporary tablespaces on a RAM disk |