Hacker News: ioltas

New comment by ioltas in "PostgreSQL 17"

ioltas — Thu, 26 Sep 2024 21:57:18 +0000

There has been a patch to extend the COPY code with pluggable APIs, adding callbacks at start, end, and for each row processed: https://commitfest.postgresql.org/49/4681/.

I'd guess that this may fit your purpose to add a custom format without having to fork upstream.

New comment by ioltas in "Ten years of improvements in PostgreSQL's optimizer"

ioltas — Wed, 17 Apr 2024 09:13:57 +0000

The bar to merge a patch that would break on-disk format is so high that it’s really impossible to reach it ;)

More seriously, we care a lot about the format of the 8k pages to ease upgrade paths as much as possible.

New comment by ioltas in "Simon Riggs has died"

ioltas — Fri, 29 Mar 2024 11:14:53 +0000

I’ve met Simon for the first time in Tokyo in 2009 for a birthday related to JPUG (Japan PostgreSQL User Group) when hot standby was getting integrated into the upstream project. I saw him last time in Prague three months ago, and we have joked about a few things while discussing about life and how things were going on as I did not go to the Postgres Europe conference for 6~7 years.

The community has lost a member, and many people have lost a friend. That’s so sudden. My thoughts go to his family and people who knew him. I’m so sad. RIP, Simon.

New comment by ioltas in "Pg_hint_plan: Force PostgreSQL to execute query plans the way you want"

ioltas — Sun, 17 Mar 2024 00:33:16 +0000

I’ll try to do something about that tomorrow, saw your ticket.

New comment by ioltas in "Pg_hint_plan: Force PostgreSQL to execute query plans the way you want"

ioltas — Sun, 17 Mar 2024 00:32:22 +0000

There are hooks for the planner and the executor, so you could force their hand quite easily with a plan extracted from a previous EXPLAIN. Being able to pass a plan at protocol level would be more efficient, for sure. I’ve worked on Postgres-XC and somewhat Postgres-XL, and that’s something that we wanted to do to generate a plan on one node, and push down the compiled plan down to other nodes to avoid the overhead of the plan computation. This stuff did that for snapshots and a few more things with an extension of the protocol.

New comment by ioltas in "Pg_hint_plan: Force PostgreSQL to execute query plans the way you want"

ioltas — Sun, 17 Mar 2024 00:25:55 +0000

Thanks, glad to hear some good feedback.

New comment by ioltas in "Pg_hint_plan: Force PostgreSQL to execute query plans the way you want"

ioltas — Sun, 17 Mar 2024 00:07:49 +0000

There are many Postgres internals that people are usually not aware of, with more than one way to develop your module. I have a repo that’s a set of plugin templates here, that should be handy for your studies: https://github.com/michaelpq/pg_plugins

New comment by ioltas in "Pg_hint_plan: Force PostgreSQL to execute query plans the way you want"

ioltas — Sat, 16 Mar 2024 11:16:15 +0000

I’ve been doing maintenance and bug fixes for this module for over 18 months now (last commit on HEAD seems to be mine), managing the last two releases. If you have questions and/or feedback, feel free.

New comment by ioltas in "Japanese houses have limited lifespans (2018)"

ioltas — Tue, 01 Aug 2023 08:09:17 +0000

Note that this one mentions 借地料, meaning that you are not an owner of the land, but the government is lending it to you for a yearly fee of 220,000 yens.

Postgres 16 highlight – JSON predicates

ioltas — Sun, 07 May 2023 08:59:48 +0000

Article URL: https://paquier.xyz/postgresql-2/2023-05-07-postgres-16-json-predicate/

Comments URL: https://news.ycombinator.com/item?id=35849388

Points: 4

# Comments: 0

New comment by ioltas in "Features I'd Like in PostgreSQL"

ioltas — Sun, 29 Jan 2023 00:38:05 +0000

It's been argued a few times that we should have the possibility to make an index invalid on sight with a proper ALTER INDEX command, yes.

New comment by ioltas in "Important PostgreSQL 14 update to avoid silent corruption of indexes"

ioltas — Fri, 10 Jun 2022 11:13:28 +0000

FWIW, amcheck can be useful but I am not 100% sure that it can detect all the broken cases either.

New comment by ioltas in "PolarDB, yet another open source database system based on PostgreSQL"

ioltas — Sun, 30 May 2021 07:10:07 +0000

Looking at their code tree, this is based on 11.2 (https://www.postgresql.org/docs/11/release-11-2.html): https://github.com/alibaba/PolarDB-for-PostgreSQL/blob/maste...

So this is code from two years ago missing stability fixes from upstream up to 11.12, at short sight.

New comment by ioltas in "A Minimal Email Client"

ioltas — Thu, 25 Feb 2021 23:18:44 +0000

mutt + mbsync with a local copy is also a nice combination.

New comment by ioltas in "PostgreSQL community impact of 2nd Quadrant purchase"

ioltas — Thu, 08 Oct 2020 01:41:32 +0000

Discussions within the core team are done on a private mailing list, so we'll know the status of things with a public announcement. Committers and contributors have no view of what gets discussed there, except if you are of course directly attached in CC of a given thread, and of course except if you are a committer also part of the core team. Four members of the current core team are committers.

New comment by ioltas in "Time Machine in macOS 10.15.3 is very slow on first full backup"

ioltas — Wed, 12 Feb 2020 11:50:13 +0000

When it comes to backup, the time it takes for the backup to complete is not a property that matters the most in my opinion. The time it takes to restore the backup matters, and being sure that the backup is able to restore and is not corrupted matters even more.

New comment by ioltas in "PostgreSQL 12"

ioltas — Thu, 03 Oct 2019 14:19:05 +0000

Here are some slides from a presentation of Andres Freud on the matter: https://anarazel.de/talks/2018-10-25-pgconfeu-pluggable-stor...

Slides 4 and 5 give some insight about the architecture changes which have been done.

New comment by ioltas in "PostgreSQL 12"

ioltas — Thu, 03 Oct 2019 14:17:12 +0000

An advantage of REINDEX CONCURRENTLY is that it becomes much easier to handle dependencies of a rebuilt index with constraints, as what the feature roughly does it to add a swapping phase between the creation and the drop portions which switches the dependencies from the old index to the new fresh one. Table-level reindex also makes life easier.

The feature is equivalent to external tools like pg_repack (formerly pg_reorg) in more performant, and has a couple of limitations to be aware of: https://www.postgresql.org/docs/12/sql-reindex.html#SQL-REIN...

New comment by ioltas in "Abacus tournaments in Japan"

ioltas — Thu, 26 Sep 2019 02:26:25 +0000

I am not sure, but doesn't it make also sense financially for some parents to send their kids to soroban classes because that's actually cheaper and more frequent in a week than other alternatives when they cannot go anymore to the public after-school services (I speak about gakudo/学童 here)?

New comment by ioltas in "The Art of PostgreSQL"

ioltas — Wed, 21 Aug 2019 10:43:42 +0000

If that was not clear, the root comment mentioned that Dimitri was a committer, and it got edited afterwards. Regarding the book, I have a copy of the first edition close by (with a dedication from the author), and for application developers I think that it provides good insight about various aspects.