Thank you I’ll check it out.
On Wed, 12 Jun 2024 at 5:55 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wednesday, June 12, 2024, nikhil kumar wrote:
>
>>
>> Can anyone please help on SMTP configuration for send gmail. If any
>> document please
On Wednesday, June 12, 2024, nikhil kumar wrote:
>
> Can anyone please help on SMTP configuration for send gmail. If any
> document please let me know.
>
This seems like an exceedingly unusual place to be asking for such help…
David J.
ne please help on SMTP configuration for send gmail. If any
> document please let me know.
>
> Thanks & Regards,
> Nikhil,
> Postgresql DBA,
> 8074430856.
>
--
Muhammad Ikram
Hi Team,
Can anyone please help on SMTP configuration for send gmail. If any
document please let me know.
Thanks & Regards,
Nikhil,
Postgresql DBA,
8074430856.
Hi,
Another point to verify is idle_in_transaction_session_timeout
What is the value of this parameter?
Regards
Michel SALAIS
De : Luiz Felipph
Envoyé : lundi 7 mars 2022 22:07
À : Tomas Vondra
Cc : Pgsql Performance
Objet : Re: Optimal configuration for server
Hi Tomas
Could you enable the connections logs and share the results when it is
reproduced, please?
It generally shows the error code and message
So, you can double-confirm if it is because of KeepAlive configuration or
something else
--
Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter
On Mon, Mar 07, 2022 at 08:51:24AM -0300, Luiz Felipph wrote:
> My current problem:
>
> under heavyload, i'm getting "connection closed" on the application
> level(java-jdbc, jboss ds)
Could you check whether the server is crashing ?
If you run "ps -fu postgres", you can compare the start time (
Em seg., 7 de mar. de 2022 às 18:10, Luiz Felipph
escreveu:
> Hi Tomas,
>
> Thank you for your reply!
>
> Thomas,
>
>> You need to monitor shared buffers cache hit rate (from pg_stat_database
>> view) - if that's low, increase shared buffers. Then monitor and tune
>> slow queries - if a slow quer
rprisedb.com> escreveu:
>
>
> On 3/7/22 12:51, Luiz Felipph wrote:
> > Hi everybody!
> >
> > I have a big application running on premise. One of my main database
> > servers has the following configuration:
> >
> > 72 CPUs(2 chips, 18 physical cores per ch
On 3/7/22 12:51, Luiz Felipph wrote:
> Hi everybody!
>
> I have a big application running on premise. One of my main database
> servers has the following configuration:
>
> 72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
> 1TB of ram or 786GB (5 ser
Em seg., 7 de mar. de 2022 às 14:18, Luiz Felipph
escreveu:
> Greatings Ranieri,
>
> Server logs I need ask to someone to get it
>
> Redhat EL 7
>
> Postgres 12
>
> Humm.. I will find out were I should put keep Alive setting
>
Are you using nested connections?
regards,
Ranier Vilela
>
t; Hi everybody!
>>
>> I have a big application running on premise. One of my main database
>> servers has the following configuration:
>>
>> 72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
>> 1TB of ram or 786GB (5 servers at all)
>>
Em seg., 7 de mar. de 2022 às 08:54, Luiz Felipph
escreveu:
> Hi everybody!
>
> I have a big application running on premise. One of my main database
> servers has the following configuration:
>
> 72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
> 1
Hi everybody!
I have a big application running on premise. One of my main database
servers has the following configuration:
72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
1TB of ram or 786GB (5 servers at all)
A huge storage( I don't know for sure what kind is, b
Hi Justin,
I am pasting once again the output of low end server , explain result
and shared_buffer size of high end machine.
-bash-4.2$ psql -p 5422
psql (12.3)
Type "help" for help.
postgres=# \c IPDS_KSEB;
You are now connected to database "IPDS_KSEB" as user "postgres".
IPDS_KSEB=# set tr
On Thu, Jul 16, 2020 at 09:13:45PM +0530, Vishwa Kalyankar wrote:
> I have two machines - one with 8GB RAM & 4core CPU and the other with 64GB
> Ram & 24 core CPU. Both machines have the same DB (Postgres 12 + Postgis
It looks like they're returning different number of rows, so definitely not the
Hi Justin,
I tried both the way, pg_dump and rsync of complete data_directory, but
the result is same.
Both the db's configurations are not same, I have tuned the db in both
machines according to https://pgtune.leopard.in.ua/#/
Below is the result of explain (analyze, buffer, settings) of bot
On Thu, Jul 16, 2020 at 09:13:45PM +0530, Vishwa Kalyankar wrote:
> Hi,
>
> I have two machines - one with 8GB RAM & 4core CPU and the other with 64GB
> Ram & 24 core CPU. Both machines have the same DB (Postgres 12 + Postgis
> 2.5.3). Same query is taking less time in low end machine whereas mo
On Mon, Jun 1, 2020 at 2:09 PM sugnathi hai wrote:
> In PGtune I can able to get configuration changes based on RAM and Disk and
> No of Connection.
>
> but if we want to recommend RAM, DISK, and No of connection based on DB size.
> any calculation is there
>
> For Examp
Hi ,
In PGtune I can able to get configuration changes based on RAM and Disk and No
of Connection.
but if we want to recommend RAM, DISK, and No of connection based on DB size.
any calculation is there
For Example, 1 TB Database how much RAM and DISK Space required for better
performance
the
Thomas Kellerer writes:
> laurent.decha...@orange.com schrieb am 17.04.2019 um 16:33:
>> On jdbc it seems this is equivalent to write :
>> statement. setMaxRows(0); // parallelism authorized, which is the default.
>>
>> Thus on my jdbc basic program if I add :
>> statement. setMaxRows(100); //
laurent.decha...@orange.com schrieb am 17.04.2019 um 16:33:
Hello Justin and thank you for your clues.
Finally I found that putting blank to the option that limits the
number of rows to retrieve (which is normal for this kind of tool)
allows PostgreSQL to parallelize the query.
On jdbc it seems
laurent.decha...@orange.com wrote:
> There is something in documentation that says that there won't be parallelism
> if " The client sends an Execute message with a non-zero fetch count."
> I am not sure what this sentence means.
The JDBC driver sends an "Execute" message to the server.
https://ww
t.com]
Envoyé : mercredi 17 avril 2019 15:57
À : DECHAMBE Laurent DTSI/DSI
Cc : Andreas Joseph Krogh; pgsql-performance@lists.postgresql.org
Objet : Re: Pg10 : Client Configuration for Parallelism ?
On Wed, Apr 17, 2019 at 09:51:02AM +, laurent.decha...@orange.com wrote:
>
> 2019-04-17 11
On Wed, Apr 17, 2019 at 09:51:02AM +, laurent.decha...@orange.com wrote:
>
> 2019-04-17 11:30:42 CEST;35895;thedbuser;thedb;0;LOG: 0: execute
> : SELECT COUNT(1) FROM big_table
> 2019-04-17 11:30:42 CEST;35895;thedbuser;thedb;0;LOCATION:
> exec_execute_message, postgres.c:1959
On 4/17/2019 4:33, Thomas Kellerer wrote:
A CTE would prevent parallelism.
You mean like always? His
SELECT count(1) FROM BigTable
would be parallel if run alone but as
WITH Data AS (SELECT count(1) FROM BigTable) SELECT * FROM Data
nothing would be parallel any more? How about:
SELECT * F
By the way
On 4/17/2019 7:26, laurent.decha...@orange.com wrote:
I can see whether there is parallelism with pg_top or barely top on the server.
PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND
38584 postgres 20 0 8863828 8.153g 8.151g R 100.0 3.2 1:23.01 p
urent DTSI/DSI
Envoyé : mercredi 17 avril 2019 13:26
À : 'Andreas Kretschmer'; pgsql-performance@lists.postgresql.org
Objet : RE: Pg10 : Client Configuration for Parallelism ?
I can see whether there is parallelism with pg_top or barely top on the server.
PID USER PR NIVIRT
2019 12:39
À : pgsql-performance@lists.postgresql.org
Objet : Re: Pg10 : Client Configuration for Parallelism ?
Am 17.04.19 um 11:51 schrieb laurent.decha...@orange.com:
>
> Here are the logs (with log_error_verbosity = verbose) :
>
>
>
> 2019-04-17 11:30:42 CEST;35895;thedbuser;thedb;
Am 17.04.19 um 11:51 schrieb laurent.decha...@orange.com:
Here are the logs (with log_error_verbosity = verbose) :
2019-04-17 11:30:42 CEST;35895;thedbuser;thedb;0;LOG: 0:
execute : SELECT COUNT(1) FROM big_table
2019-04-17 11:30:42 CEST;35895;thedbuser;thedb;0;LOCATION:
e
.
De : Andreas Joseph Krogh [mailto:andr...@visena.com]
Envoyé : mercredi 17 avril 2019 11:08
À : pgsql-performance@lists.postgresql.org
Objet : Sv: Pg10 : Client Configuration for Parallelism ?
På onsdag 17. april 2019 kl. 08:30:28, skrev
mailto:laurent.decha...@orange.com>>:
Hi,
I am w
Thanks for the tip. I have compared all settings and they are identical.
Very strange.
-Message d'origine-
De : Andreas Kretschmer [mailto:andr...@a-kretschmer.de]
Envoyé : mercredi 17 avril 2019 10:07
À : pgsql-performance@lists.postgresql.org
Objet : Re: Pg10 : Client Configur
QL use parallelism when the query is launched from psql or PgAdmin4.
However the same query launched with DBeaver (ie connected through JDBC) does
not use parallelism.
SELECT current_setting('max_parallel_workers_per_gather') gives 10 from my
session.
Is there a client configuration that pre
en the query is launched from
> psql or PgAdmin4. However the same query launched with DBeaver (ie
> connected through JDBC) does not use parallelism.
>
> SELECT current_setting('max_parallel_workers_per_gather') gives 10
> from my session.
>
> Is there a client conf
Am 17.04.19 um 08:30 schrieb laurent.decha...@orange.com:
SELECT current_setting('max_parallel_workers_per_gather') gives 10 from my
session.
Is there a client configuration that prevents from using parallelism ?
unlikely.
if i were you, i would compare all settings, using the
with DBeaver (ie connected through JDBC) does
not use parallelism.
SELECT current_setting('max_parallel_workers_per_gather') gives 10 from my
session.
Is there a client configuration that prevents from using parallelism ?
Thanks
36 matches
Mail list logo
