Questions tagged with PostgreSQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
using pgcrypto externsion in psotgres sql, following is the output for below queryies
Query 1:
```
explain analyze (select * from table_name);
```
above query taking time around 900...
0
answers
0
votes
99
views
asked 9 months agolg...
Hi there.
I noticed that my Aurora PSQL reader DBs are still getting calls even tho they are getting removed.
AFAIK The RDS DB should cut off the reader dbs if they are in a removal state, and...
0
answers
0
votes
127
views
asked 9 months agolg...
I have posted a clear bug here:
https://repost.aws/en/questions/QUXKt7jDIvTMi4SyW2jTKgbg
I even created a narrated youtube video showing and explaining the bug.
I got two answers, but both are...
2
answers
0
votes
269
views
asked 9 months agolg...
My databases in RDS was working normally but suddenly empty. The database was still there but all data inside is deleted.
I check the DB instance monitoring, event log and CloudTrail but still cannot...
4
answers
0
votes
709
views
asked 9 months agolg...
RDS IOPS limitationslg...
We have a problem with the performance of PostgreSQL RDS instance running on gp3 storage. As you can see from the attached diagrams, in an recent incident it exhausted EBSIOBalance% while the number...
1
answers
0
votes
1176
views
asked 9 months agolg...
I've reserved RDS(Postgres: db.t4g.micro) for 3 years and created same RDS instance. Current billing period is still going on but I see below line item:
$ 0.016 per RDS db.t4g.micro Single-AZ instance...
3
answers
0
votes
591
views
asked 9 months agolg...
When Postgres 11.x deprecation for Amazon RDS is ?
2
answers
0
votes
637
views
asked 9 months agolg...
why is an Amazon Stuck "upgrading" RDS Postgresql 10.23 -> 14.7 ?
0
answers
0
votes
65
views
asked 9 months agolg...
my front end is react and my backend is node/express database is postgres.
I can view my website by going to the ip address however I have troubles when trying to start the server / backend.
app is...
2
answers
0
votes
8529
views
asked 9 months agolg...
I have found a bug when calling Lambda from Postgres RDS. I am using Postgres version 13. I have created a one minute video nailing down the bug:
https://youtu.be/Y1ALUxEwzGk
I am using the following...
3
answers
1
votes
646
views
asked 10 months agolg...
Subject: Attempting export to s3 on RDS Postgres 13.10 always results in error "credentials stored with the database cluster can’t be accessed"
I have a production PostgreSQL RDS instance that has...
0
answers
0
votes
122
views
asked 10 months agolg...
Hello
We needed to update from Postgres 10.21 (t2.medium instance) to 14.7 (t3.medium instance). When we made that we found that most of our queries execute extremely slowly or they stuck and do not...
2
answers
0
votes
286
views
asked 10 months agolg...