Sean McGivern

Postgres autodiscovery settings do not exclude databases for query samples

1

We are using AlloyDB, which has a database like the auto-excluded `cloudsqladmin`, but called `alloydbadmin` (there's also an `alloydbmetadata` DB). We have this config: ```yaml collect_bloat_metrics: true database_autodiscovery: enabled: true...

PgCat should not return and log 'all servers down' when failing to obtain a connection from the pool

5

This is related to https://github.com/postgresml/pgcat/pull/822 - we were seeing this message when trialling PgCat in our production environment. We couldn't see why the Postgres server in question was down, and...

Durations reported by SHOW STATS are in milliseconds, not microseconds

3

**Describe the bug** PgBouncer reports `*_time` metrics in `SHOW STATS` in microseconds. PgCat reports the same metrics in milliseconds. https://github.com/postgresml/pgcat/tree/main#statistics-reporting says: > The stats are very similar to what PgBouncer...

Track transaction time

3

~~I'm not sure if this is the correct way to track it (on the server, with an always-outdated timestamp), but I couldn't see an obvious way to track this on...

CodeQL action times out after six hours

4

We're trying to configure CodeQL for our TypeScript monorepo. For TypeScript, it times out after six hours. We have just over a million lines of TypeScript in a private repo....

### Community Note * Please vote on this issue by adding a 👍 [reaction](https://blog.github.com/2016-03-10-add-reactions-to-pull-requests-issues-and-comments/) to the original issue to help the community and maintainers prioritize this request. * Please do...

Make retention use real child table boundaries

4

I don't think this is a bug, just looking for clarification. We are on 5.0.1 but it doesn't look like this behaviour changed. https://github.com/pgpartman/pg_partman/blob/v5.2.4/doc/pg_partman.md#retention says: > For time-based partitioning, the...

Partman behaves unexpectedly when partition size is changed, leaving gaps

4

We have a table using ID-based partitioning where we want to dynamically change the partition size such that it's _approximately_ a week's worth of data. When we _increase_ the partition...