RE: Long running processes and commit writing to disk

Поиск
Список
Период
Сортировка
От Mike Sofen
Тема RE: Long running processes and commit writing to disk
Дата
Msg-id 02f801d84b69$06336370$129a2a50$@runbox.com
обсуждение исходный текст
Ответ на Long running processes and commit writing to disk  (Shaozhong SHI <shishaozhong@gmail.com>)
Ответы Re: Long running processes and commit writing to disk  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-sql

From: Shaozhong SHI <shishaozhong@gmail.com>   Sent: Friday, April 08, 2022 9:39 AM

When long running processes got disrupted, one may not see any expected result.

How to make sure that the result of each operation is saved to disk in a loop?

Regards,

David

 

 

Simple:  don’t use a database – you’re asking to violate ACID. 

 

A database’s power comes from set-based operations.  You’re asking to do single row operations.  Use a spreadsheet...or a plain text file and treat it like a log.

 

Mike

В списке pgsql-sql по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: Long running processes and commit writing to disk
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Long running processes and commit writing to disk