Hi Guys,
Hope you are doing well.
Can someone please suggest what is one (Patroni vs PGPool II) is best for
achieving HA/Auto failover, Load balancing for DB servers. Along with this, can
you please share the company/client names using these tools for large PG
databases?
Thanks.
Regards,
In
Jason McLaurin writes:
> Is there anywhere you'd suggest we start looking for hints? I'd be
> interested in increasing relevant logging verbosity so that we can see when
> key background processes are running, both in Postgres core and Timescale.
It might be helpful to try to identify which wait
Hi Tom,
>
>
> Hmm, is it always the checkpointer that gets the OOM kill? That seems
> quite odd.
>
> What PG version is this exactly? Do you have any extensions installed?
>
> I recall having seen somebody before reporting odd slowness of trivial
> commands like BEGIN. I failed to find the thre
On Sun, Apr 2, 2023 at 5:05 PM Siddharth Jain wrote:
> What permissions does a user need to be able to drop columns from a table
> in postgres? I did read this:
> https://www.postgresql.org/docs/14/sql-grant.html
> but could not find the answer.
>
>
Because there are no permissions for that - you
Hi All,
What permissions does a user need to be able to drop columns from a table
in postgres? I did read this:
https://www.postgresql.org/docs/14/sql-grant.html
but could not find the answer.
Thanks
S.
Jason McLaurin writes:
> I'm troubleshooting an issue where about once a week, a database appears to
> lock up and then the PostgreSQL process crashes and recovers. When this
> happens, a few queries will be logged, but there is no pattern to which
> queries are executing when the crash happens, a
Hello,
I'm troubleshooting an issue where about once a week, a database appears to
lock up and then the PostgreSQL process crashes and recovers. When this
happens, a few queries will be logged, but there is no pattern to which
queries are executing when the crash happens, and the queries logged do
> Wiadomość napisana przez Laurenz Albe w dniu
> 09.02.2023, o godz. 16:42:
>
> On Thu, 2023-02-09 at 09:54 +0100, Joseph Kennedy wrote:
>> As I wtote, I would like restrict access to sensitive or restricted
>> information
>> for some users (eg. hide data of one or more clients for some data
On 4/2/23 06:21, Erik Wienhold wrote:
On 01/04/2023 08:02 CEST jian he wrote:
Hi,
https://www.postgresql.org/docs/current/functions-json.html
jsonb @@ jsonpath → boolean
Returns the result of a JSON path predicate check for the specified JSON
value. Only the first item of the result is taken i
Erik Wienhold writes:
> The result is true if any array element matches the predicate because
> predicates
> are evaluated on sequences. The documentation for executePredicate in
> src/backend/utils/adt/jsonpath_exec.c explains it:
I think the OP is correct that this is undocumented at the user
> On 01/04/2023 08:02 CEST jian he wrote:
>
> Hi,
> https://www.postgresql.org/docs/current/functions-json.html
> > jsonb @@ jsonpath → boolean
> > Returns the result of a JSON path predicate check for the specified JSON
> > value. Only the first item of the result is taken into account. If the
>
Hi,
As an end-user, I am highly interested in the patch
https://commitfest.postgresql.org/42/3595/ but I don't fully get its main goal
in its first version.
It's "for all tables" that will be implemented ?
If one needs a complete replication of a cluster, a hot standby will always be
more effi
12 matches
Mail list logo
