> Yes, but its more than fsync. > > You'd need to copy the whole table, all indexes and forks to WAL if > wal_level is set high. "if" wal_level is set high. If it's set to minimal it would be "simple" fsyncs, right? I mean: if it's at minimal it wouldn't take long, and it basically won't re-write any data. This would be very useful for data that it's not "that important", but that at the same time can be made "persistent" if needed... Am I wrong? (I'm not too familiar with WAL...) Leonardo -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general