2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
this contains absolutely no useful information. There is no PostgreSQL mechanism for automatically dropping databases, so, whatever your environment is, it's killing or restarting the container, or losing its storage. Look at the logs. Also, running Postgres in a container is a Really Bad Idea™️ unless you're using CloudNativePG
Читать полностью…
Hi team good evening if am taking database backup using pgdump and while running job has coming killed how to fix this issue ? Please help , thanks in advance…
Читать полностью…
Autovacuum is the most important part of Postgres, it's always present unless you disabled it.
Читать полностью…
What I wonder is if the LATERAL join is really the right call here. I don't see an aggregation of the result, so IMHO it could just be called in the SELECT?
Читать полностью…
WITH log_ids AS (
SELECT unnest(string_to_array($1, ',')::int4) AS log_id -- Here $1 is a string with log IDs
)
SELECT r.distnodeid, r.row_data
FROM tblimportjobslogs r
JOIN log_ids l ON r.importjobslogid = l.log_id -- Use JOIN instead of IN
LEFT JOIN LATERAL (
SELECT *
FROM sp_mruprocess(0, r.row_data, $2, $3, $4, r.distnodeid)
) AS d ON TRUE
ORDER BY r.importjobslogid ASC;
how can I use postgres v.17 incremental backups to create replica? usually i would do full backup with -Xs -R modes
how to do this now?
The above is running in a function where importjoblogid has 30000 intput
Читать полностью…
Which tools did you use to migrate databases from mysql to postgres and vice versa?
I don't wonder what kind of stuff exist and widely used. Sry for my bad english.
PostgreSQL Person of the Week interview with: Frédéric Delacourt
https://postgresql.life/post/frederic_delacourt/
I'd dare say that *a lot* of people are familiar with it.
Now go ahead and ask your question...
They didn't even bother writing the message themselves
Читать полностью…
pg_stat_activity while it currently is slow, pg_stat_statements and/or slow query logging if you can't pinpoint it.
Hi
I have slow web endpoint and wanna profile it to find bottlenecks. But I can not access the query of this endpoint.
How can find the exact query while run endpoint in browser?
Hello,
Can I send you a question in you pn. Telegramm.
Thanks
explain (analyze, verbose, buffers, costs, settings, timing, wal) <query>Читать полностью…
SELECT r.distnodeid, r.row_data
FROM tblimportjobslogs r
LEFT JOIN LATERAL (
SELECT * FROM sp_mruprocess(0, r.row_data, $2, $3, $4, r.distnodeid)
) AS d ON TRUE
WHERE r.importjobslogid IN (
SELECT unnest(string_to_array(importjoblogid, ',')::int4)
)
ORDER BY r.importjobslogid ASC;
What are the procedures trying to do:
Update TBL set fld = fld + 1;
That's a horrible construct on a multi-threaded server.
PG is cloning the row, creating bloat.
Everyone is locking.
And if FLD is an index field. LOOKOUT Below. You avoid HOT updates.
It all depends on what is being done, and why.
And switching the logic to more PG friendly (accurate) logic.
Can't you use a FDW to access tables in the same PG Cluster, but to a different set of tables?
Читать полностью…
Abstractly, but Citus does a heck of a lot more for you.
Читать полностью…