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.
I want to start using the "Application" tag so I can start segmenting my postgres cluster metrics.
My guess is that the way to do this is by setting the application_name para in the posgtres...
1
answers
0
votes
259
views
asked 4 months agolg...
I used SCT to convert the DDL below from DB2 to Aurora PostGreSQL.
DB2:
CREATE SEQUENCE XX_SCHEMA.SEQ_NO AS DECIMAL(9) START WITH 1 INCREMENT BY 1 MAXVALUE 9999999999 CYCLE;
then I got this DDL as...
0
answers
0
votes
168
views
asked 4 months agolg...
Currently, we are using the Aurora PostgreSQL instance class db.r5.large in our production environment. Due to performance-related issues, we are planning to upgrade the instance class to...
1
answers
0
votes
339
views
asked 4 months agolg...
We are using a RDS Postgres 15 and have a use case that requires disabling specific indexes using pg_index table but all attempts result in ERROR: permission denied for table pg_index .
We've tried...
1
answers
0
votes
435
views
asked 4 months agolg...
I recently purchased a custom domain through Route 53 to use for a NextJS app that I’m hosting through Amplify, connected to a Postgres database in RDS. I haven’t yet configured the custom domain with...
1
answers
0
votes
265
views
asked 4 months agolg...
We've got notified that RDS Postgres 11 will reached the end of standard support and it'll be moved to extended support automatically. Our productive environment has Multi AZ enable, so in order to...
2
answers
0
votes
268
views
asked 4 months agolg...
Hi all,
I'd like to be sure that AWS Aurora does not have any hard limits other than the ones listed on the [Quotas and...
1
answers
0
votes
448
views
asked 4 months agolg...
How can I manage large datasheets in PostgreSQL with pgvector using RAG approach with AWS Bedrock?lg...
Hi Guys!
I was doing some tests and I loaded a very long excel file into my pgvector postgresql database. Then I did a query to get the embeddings by the user id, and got the response, but when...
1
answers
0
votes
881
views
asked 4 months agolg...
I have a postgres RDS instance with db engine version 12.17, RDS instance db.m5.2xlarge. It is having temp file of 12TB, so I was modifying the DB instance parameter group, temp_file option. But when...
1
answers
0
votes
661
views
asked 4 months agolg...
We have a very large database that has been cleaned up and the size reduced from 35Tb to ~7Tb and have attempted to initiate a DMS as no other options are able to maintain up time adequately. We have...
1
answers
0
votes
230
views
asked 4 months agolg...
I'm trying to use an Aurora Postgres blue/green deployment to modify a partitioned table without downtime. My goal is to split a large partition into several smaller partitions by running the...
1
answers
0
votes
179
views
asked 4 months agolg...
I'm encountering difficulties while trying to upgrade my Amazon Aurora PostgreSQL database from version 13 to version 15 using the pg_upgrade utility. The upgrade process is failing with an error, and...
2
answers
2
votes
405
views
asked 4 months agolg...