CREATE TABLE, load and freezing
От | Pavan Deolasee |
---|---|
Тема | CREATE TABLE, load and freezing |
Дата | |
Msg-id | 2e78013d0802280108s59e52e14hae032e1e67409d6c@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: CREATE TABLE, load and freezing
Re: CREATE TABLE, load and freezing Re: CREATE TABLE, load and freezing Re: CREATE TABLE, load and freezing Re: CREATE TABLE, load and freezing |
Список | pgsql-hackers |
I had this idea sometime back. Not sure if this has been discussed before In a typical scenario, user might create a table and load data in the table as part of a single transaction (e.g pg_restore). In this case, it would help if we create the tuples in the *frozen* state to avoid any wrap-around related issues with the table. Without this, very large read-only tables would require one round of complete freezing if there are lot of transactional activities in the other parts of the database. And when that happens, it would generate lots of unnecessary IOs on these large tables. I don't know if this is a real problem for anybody, but I could think of its use case, at least in theory. Is it worth doing ? Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: