Unloading a table consistently
От | Christophe |
---|---|
Тема | Unloading a table consistently |
Дата | |
Msg-id | 67F28F8F-CDB5-4F1C-839E-956BF2EA8A6F@thebuild.com обсуждение исходный текст |
Ответы |
Re: Unloading a table consistently
Re: Unloading a table consistently |
Список | pgsql-general |
Hi, I will have a log table which, once a day or so, is copied to a file (for movement to a data warehouse), and the log table emptied. For performance, the log table on the production system has no indexes, and is write-only. (The unload process is the only reader.) To unload it, I will be doing: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; COPY log TO 'filename-path'; TRUNCATE log; COMMIT; My understanding is that I need the SERIALIZABLE isolation level so that the COPY and TRUNCATE see exactly the same view of the table. Obviously, I don't want to lose data by having the TRUNCATE delete records that appeared while the COPY was executing. Is that correct? Is there a better way to handle this kind of thing that I'm missing? Thanks! -- Xof
В списке pgsql-general по дате отправления: