asynchronous commit risk window is overly optimistic

2019-03-20 Thread Jeff Janes
https://www.postgresql.org/docs/current/wal-async-commit.html: "If the database crashes during the risk window between an asynchronous commit and the writing of the transaction's WAL records, then changes made during that transaction will be lost. The duration of the risk window is limited

how to install postgresql

2019-03-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/install-procedure.html Description: Hi, I am a newbie to postgresql. usually use to out of box installs like tar balls or pkg or rpm files. I am not able to locate this. I want to

ORDER BY LIMIT n does not work as described when using partitioned tables

2019-03-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/indexes-ordering.html Description: Dear Postgres team, First, thanks for an excellent product and great documentation. This is world class. We have found an issue with index and ORDER BY