Thread: tablespaces and ramdisks

tablespaces and ramdisks

From
"Merlin Moncure"
Date:
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?

I'm looking for a way to turn off syncing completely for a table.
Temporary tables do this, but they can only be accessed from a single
backend.

Merlin

Re: tablespaces and ramdisks

From
Tom Lane
Date:
"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