tablespaces and ramdisks

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: tablespaces and ramdisks
Date: 2004-08-09 15:29:57
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AF2C@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-08-09 16:35:10 Re: tablespaces and ramdisks
Previous Message Shridhar Daithankar 2004-08-09 14:46:47 Re: The black art of postgresql.conf tweaking