pgsql: Update ssl test certificates and keys

2019-01-03 Thread Peter Eisentraut
Update ssl test certificates and keys Debian testing and newer now require that RSA and DHE keys are at least 2048 bit long and no longer allow SHA-1 for signatures in certificates. This is currently causing the ssl tests to fail there because the test certificates and keys have been created in v

pgsql: Update ssl test certificates and keys

2019-01-03 Thread Peter Eisentraut
Update ssl test certificates and keys Debian testing and newer now require that RSA and DHE keys are at least 2048 bit long and no longer allow SHA-1 for signatures in certificates. This is currently causing the ssl tests to fail there because the test certificates and keys have been created in v

pgsql: Update ssl test certificates and keys

2019-01-03 Thread Peter Eisentraut
Update ssl test certificates and keys Debian testing and newer now require that RSA and DHE keys are at least 2048 bit long and no longer allow SHA-1 for signatures in certificates. This is currently causing the ssl tests to fail there because the test certificates and keys have been created in v

pgsql: Update ssl test certificates and keys

2019-01-03 Thread Peter Eisentraut
Update ssl test certificates and keys Debian testing and newer now require that RSA and DHE keys are at least 2048 bit long and no longer allow SHA-1 for signatures in certificates. This is currently causing the ssl tests to fail there because the test certificates and keys have been created in v

pgsql: Improve ANALYZE's handling of concurrent-update scenarios.

2019-01-03 Thread Tom Lane
Improve ANALYZE's handling of concurrent-update scenarios. This patch changes the rule for whether or not a tuple seen by ANALYZE should be included in its sample. When we last touched this logic, in commit 51e1445f1, we weren't thinking very hard about tuples being UPDATEd by a long-running conc

pgsql: Improve ANALYZE's handling of concurrent-update scenarios.

2019-01-03 Thread Tom Lane
Improve ANALYZE's handling of concurrent-update scenarios. This patch changes the rule for whether or not a tuple seen by ANALYZE should be included in its sample. When we last touched this logic, in commit 51e1445f1, we weren't thinking very hard about tuples being UPDATEd by a long-running conc

pgsql: Improve ANALYZE's handling of concurrent-update scenarios.

2019-01-03 Thread Tom Lane
Improve ANALYZE's handling of concurrent-update scenarios. This patch changes the rule for whether or not a tuple seen by ANALYZE should be included in its sample. When we last touched this logic, in commit 51e1445f1, we weren't thinking very hard about tuples being UPDATEd by a long-running conc

pgsql: Improve ANALYZE's handling of concurrent-update scenarios.

2019-01-03 Thread Tom Lane
Improve ANALYZE's handling of concurrent-update scenarios. This patch changes the rule for whether or not a tuple seen by ANALYZE should be included in its sample. When we last touched this logic, in commit 51e1445f1, we weren't thinking very hard about tuples being UPDATEd by a long-running conc

pgsql: Improve ANALYZE's handling of concurrent-update scenarios.

2019-01-03 Thread Tom Lane
Improve ANALYZE's handling of concurrent-update scenarios. This patch changes the rule for whether or not a tuple seen by ANALYZE should be included in its sample. When we last touched this logic, in commit 51e1445f1, we weren't thinking very hard about tuples being UPDATEd by a long-running conc

pgsql: Improve ANALYZE's handling of concurrent-update scenarios.

2019-01-03 Thread Tom Lane
Improve ANALYZE's handling of concurrent-update scenarios. This patch changes the rule for whether or not a tuple seen by ANALYZE should be included in its sample. When we last touched this logic, in commit 51e1445f1, we weren't thinking very hard about tuples being UPDATEd by a long-running conc

pgsql: Use symbolic references for pg_language OIDs in the bootstrap da

2019-01-03 Thread Tom Lane
Use symbolic references for pg_language OIDs in the bootstrap data. This patch teaches genbki.pl to replace pg_language names by OIDs in much the same way as it already does for pg_am names etc, and converts pg_proc.dat to use such symbolic references in the prolang column. Aside from getting rid

pgsql: Move the built-in conversions into the initial catalog data.

2019-01-03 Thread Tom Lane
Move the built-in conversions into the initial catalog data. Instead of running a SQL script to create the standard conversion functions and pg_conversion entries, put those entries into the initial data in postgres.bki. This shaves a few percent off the runtime of initdb, and also allows accurat