On 6 Feb 2021, at 3:37, Ron wrote:
On 2/5/21 10:22 AM, Rob Sargent wrote:
On 2/5/21 9:11 AM, Ron wrote:
Obviously... don't use 300 threads.
No, no Ron. Clearly the answer is more CPUs
I hope you're being sarcastic.
A reasonable conjecture… though there is the consideration that 300
CP
On 2/5/21 10:22 AM, Rob Sargent wrote:
On 2/5/21 9:11 AM, Ron wrote:
Obviously... don't use 300 threads.
No, no Ron. Clearly the answer is more CPUs
I hope you're being sarcastic.
--
Angular momentum makes the world go 'round.
On 2/5/21 9:11 AM, Ron wrote:
Obviously... don't use 300 threads.
No, no Ron. Clearly the answer is more CPUs
Obviously... don't use 300 threads.
On 2/5/21 2:15 AM, Atul Kumar wrote:
ok, How do I resolve it ?
Any suggestions ?
On 2/5/21, Ron wrote:
Your problem screams "IO saturation".
On 2/4/21 12:07 PM, Atul Kumar wrote:
There is no error message, when I try to connect the database while
running
Hello Jain
On Fri, Feb 5, 2021 at 1:16 PM Jain, Ankit wrote:
> Did you try modifying the firewall settings ?
>
>
>
> Add postgres service to the firewall. If that doesn’t work, explicitly
> open the port 5433 in the firewall.
>
>
> Anyway, given these settings, "psql -p 5433 -h localhost" should
On Fri, 2021-02-05 at 10:57 +0530, Jagmohan Kaintura wrote:
> When we do an implementation from Oracle to PostgreSQL in trigger for clause
> like :
> updating(column_name) ==> (TG_OP='UPDATE' and OLD.column_name IS
> DISTINCT FROM NEW.column_name)
> But this condition would mostly not be
Did you try modifying the firewall settings ?
Add postgres service to the firewall. If that doesn’t work, explicitly open the
port 5433 in the firewall.
From: Joao Miguel Ferreira
Sent: Thursday, February 4, 2021 10:08 AM
To: Tom Lane
Cc: dep...@depesz.com; pgsql-general
Subject: Re: cant con
ok, How do I resolve it ?
Any suggestions ?
On 2/5/21, Ron wrote:
> Your problem screams "IO saturation".
>
> On 2/4/21 12:07 PM, Atul Kumar wrote:
>> There is no error message, when I try to connect the database while
>> running vacuumdb with 300 jobs, it gets stuck.
>>
>> On Thursday
