Re: [BUGS] pg_dump's results have quite different size

Поиск
Список
Период
Сортировка
От Kaijiang Chen
Тема Re: [BUGS] pg_dump's results have quite different size
Дата
Msg-id CAAkGvS-qnQ8ZGJ0C-ttiym6QVpHyDogZa=_fPdUbSyKrt85zPA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] pg_dump's results have quite different size  (Kaijiang Chen <chenkaijiang@gmail.com>)
Ответы Re: [BUGS] pg_dump's results have quite different size  (Oleksandr Shulgin <oleksandr.shulgin@zalando.de>)
Список pgsql-bugs
Дерево обсуждения
I found that it is because I run the pg_dump on standby and it conflicts with the stream replication. I enlarge the max_standby_streaming_delay. It should work.

On Fri, Dec 9, 2016 at 12:27 PM, Kaijiang Chen <chenkaijiang@gmail.com> wrote:
Hi, I have postgresql 9.4.10, CentOS 6.5, 64 bit. I got the source codes, built and gmake install. 

I pg_dump the database 3 times everyday. The weird thing is that the sizes of the dump files are sometimes quite different.

For example, the file dumped in 7am is 1.5G and the file dumped in 11am is 0.91G -- about 60% gap! But no massive deletion happened. Only some insertion/updating (less than 10K) in between 2 dump operations. Un-logical to have different sizes.

Note that in about 70% cases, file sizes are similar to each other and keeps increasing a little bit, which is very logical. But sometimes I got weird things as described above.

Is that a bug? Or something else?

Regards,
Kaijiang


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14465: cursor for insert into select ... returningcann't streaming fetch?
Следующее
От: digoal@126.com
Дата:
Сообщение: [BUGS] BUG #14466: can with recursive query add LOOPth variable?