RE: pg_xlog unbounded growth

2018-02-07 Thread Alex Ignatov
Have you tried archive_command='/bin/true' as Andreas wrote? -Original Message- From: Stefan Petrea [mailto:stefan.pet...@tangoe.com] Sent: Wednesday, January 24, 2018 2:48 PM To: pgsql-performa...@postgresql.org Subject: pg_xlog unbounded growth Hello, This email is structured in sec

RE: Bad estimates

2017-11-22 Thread Alex Ignatov
It doesn’t help in this case. -- Alex Ignatov Postgres Professional: <http://www.postgrespro.com> http://www.postgrespro.com The Russian Postgres Company From: Don Seiler [mailto:d...@seiler.us] Sent: Wednesday, November 22, 2017 5:49 PM To: Artur Zając Cc: pgsql-perfo

RE: Query became very slow after 9.6 -> 10 upgrade

2017-11-22 Thread Alex Ignatov
setup_cost | 1000 parallel_tuple_cost | 0.1 random_page_cost | 4 seq_page_cost| 1 Can you generate plan with random_page_cost = 4? -- Alex Ignatov Postgres Professional: <http://www.postgrespro.com> http://www.postgrespro.com The Russian Postgres Company

RE: Query became very slow after 9.6 -> 10 upgrade

2017-11-22 Thread Alex Ignatov
Hello! What about : select name,setting from pg_settings where name like '%_cost'; -- Alex Ignatov Postgres Professional: <http://www.postgrespro.com> http://www.postgrespro.com The Russian Postgres Company From: Dmitry Shalashov [mailto:skau...@gmail.com]