Re: Faster pg_resore with autovacuum off?
| От | Scott Ribe |
|---|---|
| Тема | Re: Faster pg_resore with autovacuum off? |
| Дата | |
| Msg-id | 154A742E-51A3-4A56-A570-65B9E6A14A4D@elevated-dev.com обсуждение исходный текст |
| Ответ на | Re: Faster pg_resore with autovacuum off? (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: Faster pg_resore with autovacuum off?
Re: Faster pg_resore with autovacuum off? |
| Список | pgsql-admin |
> On Jul 27, 2024, at 1:48 PM, Ron Johnson <ronljohnsonjr@gmail.com> wrote: > > You can't forget to enable autovacuum when it's in the same script as the pg_restore. Similar argument applies to turning off fsync, which I have found to sometimes make a significant difference (depending onhardware). The other argument I've seen, that if there's a crash during restore you'll have a corrupted database, is bogus. What areyou going to try to do with a database if there's a crash during restore???
В списке pgsql-admin по дате отправления: