I did profiling of the application and it seems most of the CPU consumption
is for executing the stored procedure. Attached is the screenshot of the
profile
--Ayub
On Wed, Jun 9, 2021 at 5:47 PM Ayub Khan wrote:
> attached is the screenshot of RDS performance insights for AWS and it
> shows hi
On Thu, Jun 10, 2021 at 11:41:09AM +0500, Haseeb Khan wrote:
> You mean, So should I request for to increase the System Ram from 32 Gb to 64
> Gb and keep the same parameter setting.Is it ?
No - I don't know how large your DB is, or the other question that I asked.
So I can't possibly make a sugg
On 6/9/21 9:50 PM, Dean Gibson (DB Administrator) wrote:
> Having now successfully migrated from PostgreSQL v9.6 to v13.2 in
> Amazon RDS, I wondered, why I am paying AWS for an RDS-based version,
> when I was forced by their POLICY to go through the effort I did? I'm
> not one of the crowd who
Please work through the Slow Query wiki page and try to provide as much
information as possible. It's too hard to try to help if each communication
includes only a fraction of the requested information.
On Thu, Jun 10, 2021 at 04:33:51PM +0500, Haseeb Khan wrote:
> PFB the query and there are man
On Wed, Jun 9, 2021 at 6:50 PM Dean Gibson (DB Administrator) <
postgre...@mailpen.com> wrote:
> Having now successfully migrated from PostgreSQL v9.6 to v13.2 in Amazon
> RDS, I wondered, why I am paying AWS for an RDS-based version, when I was
> forced by their POLICY to go through the effort I
On Thu, Jun 10, 2021 at 4:06 AM Ayub Khan wrote:
> I did profiling of the application and it seems most of the CPU
> consumption is for executing the stored procedure. Attached is the
> screenshot of the profile
>
That is of your tomcat server? If that is really a profile of your CPU
time (rath
On 2021-06-10 03:29, Andrew Dunstan wrote:
On 6/9/21 9:50 PM, Dean Gibson (DB Administrator) wrote:
First, pg_dumpall (v13.3) errors out, because on RDS, you cannot be a superuser, &
it tries to dump protected stuff. If there is a way around that, I'd like to know it,
even though it's not an
Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator) <
postgre...@mailpen.com> escreveu:
> On 2021-06-10 03:29, Andrew Dunstan wrote:
>
> On 6/9/21 9:50 PM, Dean Gibson (DB Administrator) wrote:
>
> First, pg_dumpall (v13.3) errors out, because on RDS, you cannot be a
> superuser,
Ayub,
Ideally when i have to deal with this,
i run a pgbench stress test locally on the db server on lo interface
which does not suffer mtu / bandwidth saturation issues.
then run the same pgbench from a remote server in the same subnet as the
app and record the results and compare.
that helps me
On 2021-06-10 09:54, Ranier Vilela wrote:
Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator)
mailto:postgre...@mailpen.com>> escreveu:
I guess I don't understand what that option does:
=>pg_dumpall -U Admin --exclude-database MailPen >zzz.sql
pg_dump: error: coul
"Dean Gibson (DB Administrator)" writes:
> On 2021-06-10 09:54, Ranier Vilela wrote:
>> Your cmd lacks =
>> =>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql
> I read that before posting, but missed that. Old command line patterns
> die hard!
> However, the result was the same: 3.5GB b
On 6/10/21 2:00 PM, Tom Lane wrote:
> "Dean Gibson (DB Administrator)" writes:
>> On 2021-06-10 09:54, Ranier Vilela wrote:
>>> Your cmd lacks =
>>> =>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql
>> I read that before posting, but missed that. Old command line patterns
>> die hard!
On 2021-06-10 11:23, Andrew Dunstan wrote:
On 6/10/21 2:00 PM, Tom Lane wrote:
"Dean Gibson (DB Administrator)" writes:
... Do I need quotes on the command line?
On 2021-06-10 09:54, Ranier Vilela wrote:
Your cmd lacks =
=>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql
I read [the m
On 2021-06-10 10:43, Dean Gibson (DB Administrator) wrote:
On 2021-06-10 09:54, Ranier Vilela wrote:
Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator)
mailto:postgre...@mailpen.com>> escreveu:
... Do I need quotes on the command line?
See at:
https://www.postgresql.or
14 matches
Mail list logo
