Re: PostgreSQL as advanced job queuing system

2024-03-22 Thread Robert Treat
s has as the basis for a queue system. And yeah, I suspect this may become a hot topic again now that Redis is moving away from open source: https://redis.com/blog/redis-adopts-dual-source-available-licensing/ Robert Treat https://xzilla.net

Re: Question about PostgreSQL upgrade from version 12 to version 15

2024-03-21 Thread Robert Treat
version to another. > > > Joe Conway gave a very good presentation on this topic recently: > https://www.postgresql.eu/events/fosdem2024/schedule/session/5127-collation-challenges-sorting-it-out/ > As a bonus, if you do decide to reindex, you'll also benefit from the index deduplication work that was introduced in v13, which should help reduce disk space and make queries a little faster. Robert Treat https://xzilla.net

Re: Seeing high query planning time on Azure Postgres Single Server version 11.

2024-03-09 Thread Robert Treat
version of Postgres (v11) and not even the latest release of said EOL version. And if I am not mistaken, "Azure Postgres single server version" is also deprecated, so you should really focus on getting upgraded to something more modern. Robert Treat https://xzilla.net On Sat, Mar 9, 20

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Robert Treat
s console. That said, my son liked lua when he was a kid, so yeah, there's lots of options, even if plpgsql on the command line isn't strictly one of them. Robert Treat https://xzilla.net

Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL

2022-10-23 Thread Robert Treat
ernatives might be more what you are angling towards. Hope that helps. Robert Treat https://xzilla.net

Re: LwLocks contention

2022-04-25 Thread Robert Treat
to see what relations are in play for the queries that are waiting on said lwlocks (especially trying to map write queries to tables/indexes). Robert Treat https://xzilla.net

Re: impact of version upgrade on fts

2021-04-25 Thread Robert Treat
he extension itself to work in the new version of Postgres. Specifics around that will also depend on how you instead to run your upgrade process. Robert Treat https://xzilla.net

Re: Christopher Browne

2020-11-05 Thread Robert Treat
v/24248903/36575/36575_original.jpg, he is the one in the back, holding up the sign. Robert Treat https://xzilla.net

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-04-08 Thread Robert Treat
oles and/or the superuser bit from all roles (not that I would recommend that to anyone) but that these roles cannot be removed without some serious heavy lifting. Given that, I think I would tend to agree, describing them more consistently as "system roles" is probably warranted. Robert Treat https://xzilla.net https://credativ.com