Re: tablespaces and ramdisks

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

9 августа 2004 г. в 13:35:59

"Merlin Moncure"  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

tablespaces and ramdisks

От:

"Merlin Moncure" <merlin.moncure@rcsonline.com>

Дата:

9 августа 2004 г. в 12:30:19

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