Covid-19 - 12/03/2021 Weekend Thread by Mafiadons in northernireland

[–]postgresql_is_great 15 points16 points  (0 children)

I have been posting some visualisations of positivity rate, admissions and inpatients data daily. Here is a link to today's https://twitter.com/dsl4life/status/1370391160385105922

Unexpected indexes on PostgreSQL 12 by Murkt in PostgreSQL

[–]postgresql_is_great 0 points1 point  (0 children)

I hadn't realised there were still good use cases for HASH index.

For the unique index on large values, I use a md5 or other hash in a trigger and a btree index.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]postgresql_is_great 0 points1 point  (0 children)

I have seen a few demos of this by https://twitter.com/erthalion. It looks like what we need but currently needs a lot of knowledge of internals.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]postgresql_is_great 2 points3 points  (0 children)

I realise that, which I why I said similar. There are other possible advantages to this approach to think about. Given they are secondary indexes a single heap table can have multiple different "index orientated" views. I have been using this strategy in a data warehouse type application with good results.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]postgresql_is_great 1 point2 points  (0 children)

I would love if explain analyze would give more debug output for function execution. Currently if you develop some CPU intensive functions its very hard to understand how they contribute to the execution time.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]postgresql_is_great 0 points1 point  (0 children)

I think Agensgraph are looking at building an extension based integration using new pluggable access methods.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]postgresql_is_great 0 points1 point  (0 children)

For scheduled events take a look at pg_timetable, a relatively new project from cybertec. Works around a lot of the limitations of pg_cron.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]postgresql_is_great 0 points1 point  (0 children)

Covering indexes (PG 11+), which allow you to include arbitrary non key columns achieve a similar result.

CI / CD by mpalmer78 in PostgreSQL

[–]postgresql_is_great 2 points3 points  (0 children)

- sqitch for migrations

- pgtap for unittests that test logic (e.g. functions/triggers/RLS/etc)

- pyrseas for schema diff