Adds the pgmq extension to support queuing #1120
Merged
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
olirice
commented
Aug 14, 2024
samrose
approved these changes
Aug 14, 2024
olirice
commented
Aug 14, 2024
olirice
commented
Aug 14, 2024
samrose
approved these changes
Aug 19, 2024
8db4319 to
29ef673
Compare
darora
approved these changes
Sep 11, 2024
sweatybridge
approved these changes
Sep 11, 2024
|
@olirice - FYI, pgmq (for partitioned queue feature) depends on pg_partman < 5. It is in the backlog to add support for pg_partman 5 though. |
|
thanks @ChuckHend, saved me an hour 🙌 |
…ble since they use 3 schemas
4cd1171 to
880db79
Compare
damonrand
pushed a commit
to cepro/postgres
that referenced
this pull request
Jun 15, 2025
* add pgmq SQL only extension * revert accidental file inclusion * add public interface test coverage * order by namespace for tables in interface test to make timescale stable since they use 3 schemas * pgmq in prime * update to pgmq 1.4.2 * regression tests for pgmq * add pgmq migration test script * add pg_partman * remove pg_partman_bgq from test suite postgresql.conf * checkin broken test * checkin broken test 2 * bump pgmq to 1.4.4 * sync test outputs and pg_partman with 1.4.4 * add pgmq to supautils privileged extensions
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Adds pgmq and its optional dependency pg_partman to support queues and partitioned queues
pg_partman is installed without the optional background worker. We will document using pg_cron to schedule calls
run_maintenance_proc();. That is consistent with RDS's usage of pg_partman