Re: tablespaces and ramdisks - Mailing list pgsql-performance

From Tom Lane
Subject Re: tablespaces and ramdisks
Date
Msg-id 16003.1092069310@sss.pgh.pa.us
Whole thread Raw
In response to tablespaces and ramdisks  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> If you use tablespaces to put a high-update, non-critical table on a
> ramdisk, will updates to that table will still cause the WAL files to
> sync?

Sure.  Postgres has no way of knowing that there's anything special
about such a tablespace.

> I'm looking for a way to turn off syncing completely for a table.

There isn't one, and I'm not eager to invent one.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: tablespaces and ramdisks
Next
From: Rory Campbell-Lange
Date:
Subject: Help specifying new machine