Re: [PERFORM] tablespaces and ramdisks

2004-08-09 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> 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 lo

[PERFORM] tablespaces and ramdisks

2004-08-09 Thread Merlin Moncure
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