Questions tagged [postgresql-extensions]
Additional modules supplied by the Postgres project but not installed by default.
106 questions
0
votes
1
answer
35
views
WAL record action code dictionary
I'm exploring the module wal2json for the first time. I've set up the replication slot using the ReadMe examples.
When peeking the replication slot, every data value begins with an "action" ...
- 5,951
0
votes
0
answers
58
views
ERROR: called Result::unwrap()on anErr value: ()
I was working in pgml extension. I installed and ran it through docker.
When I tried to tune an existing model named cssupport/t5-small-awesome-text-to-sql based on my new dataset (this dataset is ...
1
vote
1
answer
66
views
Optimizing Query to Retrieve Names from pg_buffercache View in PostgreSQL
I had a database with large amount of tables / partition tables where I need to retrieve the database name, relation name, parent relation name and tablespace name instead of their respective OIDs ...
- 55
0
votes
1
answer
60
views
CloudSQL for Postgres S3 extension
In AWS RDS for Postgres, there is an extension called AWS_S3 that provides functions within Postgres that allow me to import data directly from a bucket into a table and export data from a table ...
- 45
0
votes
1
answer
132
views
PostgreSQL stored C function is 60 times slower than standalone C code
I am trying to build stored function in C, which will take one array of bigint as argument, and return another array which is copy of parameter array but with all elements incremented by 1.
My problem ...
- 11
1
vote
0
answers
86
views
Writing .spec files for PostgreSQL isolation tests
I am developing a PostgreSQL extension for which I would like to run some tests with concurrent connections. If I understand the documentation correctly, I should be able to do so using the PGXS ...
- 824
0
votes
1
answer
158
views
Regression testing Issue [make installcheck]
For the regression tests:
After running make installcheck on my_extension getting error:
echo "+++ regress install-check in +++" && /Users/spartacus/.pgenv/pgsql-15.0/lib/pgxs/src/...
- 133
1
vote
1
answer
484
views
How is PostgreSQL's extension system implemented?
I am interested in how PostgreSQL's extension system is implemented. How can a postgres server call user-defined C which is built separately from the server.
This question comes from Reddit u/...
- 65.8k
1
vote
0
answers
411
views
Trying to use the "Object Explorer" in pgAdmin crashes server when pg-strom is installed
I'm trying to get to the bottom of some unusual behavior with pgAdmin4 when the GPU acceleration extension pg-strom is installed in PostgreSQL 14 and 15. Simple queries seem to work fine, but when ...
- 111
5
votes
3
answers
3k
views
how to match pg_repack binary and db version
I am using this command sudo apt-get install postgresql-11-repack to install pg_repack(default to 1.4.8).
postgresql-11-repack is already the newest version (1.4.8-1.pgdg20.04+1).
when i run "...
- 101
1
vote
2
answers
708
views
Postgresql doesn't working with Citus and pg_stat_statements at the same time
So, I built the PostgreSQL with citus extension in docker.
I use the official documentation in citus, then I run this command in the terminal.
docker run -d -v /root/volumes/citus-data:/data --...
1
vote
2
answers
2k
views
What does it mean by PostgreSQL's ERROR: schema XX is not a member of extension YY?
I have two PostgreSQL (14.5, Ubuntu 22.04) extensions A and B that each creates some functions in a common schema schm.
Now I am having trouble re-creating the two extensions as there seems to be ...
- 3,840
0
votes
1
answer
622
views
Filter rows using a probabilistic filter (bloom filter or cuckoo filter) in Postgres
I have a large table (~1B rows) with a btree index on a single bytea column (~20GB, but fits in memory).
I'd like to send a query from the client with a probabilistic filter (e.g. a bloom filter or a ...
- 155
4
votes
1
answer
2k
views
Where temp table data goes after creation?
As far as I can understand temp_buffers setting serve for storing temp tables data.
But as I have created a temp table immediately files gets created for it inside PGDATA along with the main database.
...
- 2,276
0
votes
1
answer
88
views
Is there a way to a maintain the function signature in C and not in a SQL file?
Currently the docs says,
There are two ways you can build a composite data value (henceforth a “tuple”): you can build it from an array of Datum values, or from an array of C strings that can be ...
- 65.8k
0
votes
1
answer
507
views
What arguments get passed with PG_FUNCTION_ARGS (with the V1 convention)?
PostgreSQL Documents all their C functions with a "V1" interface, but they don't actually show what they get,
PG_FUNCTION_INFO_V1(add_one);
Datum
add_one(PG_FUNCTION_ARGS)
{
int32 arg ...
- 65.8k
0
votes
1
answer
290
views
C Extension: Is it faster to return a set with ValuePerCall or Materialize mode?
PostgreSQL documents it's Set Returning Functions with C extensions like this,
C-language functions have two options for returning sets (multiple rows).
In one method, called ValuePerCall mode, a ...
- 65.8k
1
vote
1
answer
216
views
Would you recommend to use PL/R in 2021 or is it dead? [closed]
And for many years there exists a PostgreSQL extension to use GNU-R directly in the database: https://www.joeconway.com/plr/
Ubuntu packages are also provided and updated for latest PG: https://...
- 857
5
votes
2
answers
2k
views
List PostgreSQL extensions per database
I have a Postgres 9.5 server with 30 databases.
I would like to find out which database uses which extension(s) in one go, preferably in a query that is usable in pgAdmin.
I know that SELECT * FROM ...
- 151
0
votes
1
answer
4k
views
Create GIN index in a schema with the pg_trgm extension
I'm migrating entities from the public schema into a new one, let's call it myschema. Originally, the pg_trgm extension was installed and the index was created in a schema migration with:
CREATE ...
- 103
2
votes
1
answer
3k
views
Can't enable wal2json in postgres 12 docker image
I'm trying to enable wal2json in an image extended from postgres:12 image. But i'm getting an error:
postgres=# create extension wal2json;
ERROR: could not open extension control file "/usr/share/...
- 123
0
votes
1
answer
364
views
Custom Aggregate Postgresql C extension with input as initial condition
Is there a way to write a custom aggregate Postgresql C extension function that takes an input from the user and sets it as the initial condition? If so, how?
I’ve written several Postgresql ...
0
votes
1
answer
1k
views
In Amazon RDS, how does one enable PLV8 extension?
I see it is available. Just can't find the right documentation to help me enable it.
From the docs, I entered the following command and got:
postgres=> select * from pg_available_extensions where ...
- 153
9
votes
1
answer
4k
views
How to select functions that belong in a given extension in PostgreSQL?
I am trying to compose a SELECT from pg_catalog that pulls function name, its schema name and the name of extension that created this function.
To pull function list I use (a simplified version)
...
- 571
1
vote
1
answer
282
views
Can I do a backup without extension functions?
I use the PostGIS extension on my database. The thing is when I do a backup and then a restore, all the PostGIS functions give a warning during the restore process, because the functions already exist,...