On Mon, Dec 9, 2024 at 13:16 Eric Schwarzenbach
wrote:
> Hi,
>
> Could one transaction (one that should be relatively simple and short)
> cause another complex, long running transaction (involving INSERTS, on a
> table the first transaction may be reading from) to take many orders of
> magnitude
On Thu, Feb 1, 2024 at 04:42 Laurenz Albe wrote:
> Today, the only feasible solution is not to create more than 64
> subtransactions
> (savepoints or PL/pgSQL EXCEPTION clauses) per transaction.
Sometimes, a single subtransaction is enough to experience a bad
SubtransSLRU spike:
https://postgre
On Mon, Apr 12, 2021 at 14:57 Andres Freund wrote:
> Without knowing the proportion of LockManager wait events compared to
> the rest it's hard to know what to make of it.
These OSS tools can be useful to understand the proportion:
- pgCenter
https://github.com/lesovsky/pgcenter
- pg_wait_samp
Consider WAL-G. It works well with GCS nowadays. We have a good fresh
experience of using it on GCP, for multi-TB databases.
BTW, what is your opinion on using GCE snapshots in this context? You
mention that you've consider them. Thoughts?
Thanks,
Nik
On Thu, Dec 5, 2019 at 09:48 Craig Jackson
Hi,
On Tue, Jul 16, 2019 at 4:00 PM Vladimir Ryabtsev
wrote:
> I am querying a remote server through a foreign table definition.
>
> CREATE TABLE example (id integer, product product_enum, status status_enum)
>
...
> When I am querying the foreign table on enum predicate like
>
> select * from
Hello Mariel,
1) Have you tried to run “CHECKPOINT;” on the standby to perform
restartpoint explicitly? It is possible.
2) If we talk about streaming replication, do you use replication slots? If
so, have you checked pg_replication_slots and pg_stat_replication? They can
help to troubleshoot stre
On Tue, Dec 19, 2017 at 7:47 PM, Habib Nahas wrote:
> Hi,
>
> We operate an RDS postgres 9.5 instance and have periodic CPU spikes to
> 100%. These spikes appear to be due to autoanalyze kicking on our larger
> tables.
>
How did you draw such conclusion? How did you find that autoanalyze is the
