Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
4 votes
Accepted

Postgres select on a very large table

You are currently removing 855 rows using a filter on col3 and col4, in order to find 10 rows which pass that filter. So as I feared, the things that fail that filter might be rarer than other things,...
jjanes's user avatar
  • 40k
3 votes

Presto SQL: TO_UNIXTIME

you need to cast the string '2018-08-24 06:42:16' to one of the allowed types TO_UNIXTIME(cast ('2018-08-24 06:42:16' as timestamp) ) new_year_ut or TO_UNIXTIME( timestamp '2018-08-24 06:42:16' )
Jasen's user avatar
  • 3,583
3 votes

AWS RDS SQL Server Instance, Question in Maintenance Plan

Why limiting access? since we are not the DBAs for these servers? Amazon RDS is a Platform-as-a-Service offering, meaning the vendor is taking care of the infrastructure and platform setup, ...
HandyD's user avatar
  • 9,972
2 votes
Accepted

Do I need to restart microservices pointing a database (through hostname) after changing IP address behind?

Generally IP clients use a DNS service to translate host names to IP addresses, and they cache the IP addresses for some period of time, called a Time-to-live (TTL) suggested by the DNS server. SQL ...
David Browne - Microsoft's user avatar
2 votes

Is MySQL trigger for 100 Millions daily updates can impact data base cluster performance?

It is true that triggers incur some cost to the database. You should think about it in terms of the number of index writes. When you insert or update a table without triggers, you can estimate the ...
Bill Karwin's user avatar
2 votes
Accepted

Can AWS Aurora High Availability allow different Schema on Replicas?

AWS Aurora's replication is more akin to Always On Availability Group. The primary pushes storage changes to other replicas. You don't get to make schema changes on the subscriber. More details are ...
Brent Ozar's user avatar
1 vote

SQL Server Combine Partioned Backups Files to One?

Every day you receive a SQL Server 2016 database backup set that is composed of multiple partitioned .bak files of size 1GB each You mean a striped backup? If that's so, the lengths they'd have to go ...
Sean Gallardy's user avatar
1 vote

Best way to "stop" Aurora RDS PostqreSQL read instance during off-peak hours?

I think it really comes down to whether peak times just stress it on the read end or if the read and write are both stressed. If you are just read stressed then I would look at creating read replicas ...
Xeru98's user avatar
  • 11
1 vote

AWS RDS snapshot restore from west to east

Yes, you are fine. Every snapshot contains all information required to restore the Amazon RDS instance. You can think of them as "full backups", but they are actually slightly more ...
John Rotenstein's user avatar
1 vote

Can AWS Aurora High Availability allow different Schema on Replicas?

This may not have been the case when the question was asked but the docs now show a table that clearly answers this question. So you can have a different schema in binlog replicas but not Aurora ...
totalhack's user avatar
  • 111
1 vote

Migrating MySQL 8.0.20 database to AWS Aurora

Found Aurora 3 compatible with mysql8.0.23 this week on aws. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.3010.html
Jan Sobolewski's user avatar
1 vote

Migrating MySQL 8.0.20 database to AWS Aurora

One major difference between MySQL and Aurora is that Aurora only runs in the AWS cloud. You can't run Aurora in any other hosted environment, or on a development laptop or workstation, or an embedded ...
Bill Karwin's user avatar
1 vote

Migrating MySQL 8.0.20 database to AWS Aurora

The biggest potential problems with going backward from 8.0: CTEs Windowing functions new COLLATIONs Various minor syntax changes that are best found by trying the transfer. If you are not using ...
Rick James's user avatar
  • 78.3k
1 vote
Accepted

How to setup continuous DB replication from on-prem MS SQL server to PostgreSQL on AWS RDS without reconfiguring source machine?

This is a very rough thought process on one thing you could do (and I'm sure there's ways to fine tune this idea, which I'll continue to update as I think of them) but you can leverage a couple of the ...
J.D.'s user avatar
  • 37.8k
1 vote

Does Postgres read blocks sequentially, even if a disk is high-latency?

In the case of bitmap heap scan, it can issue async block reads. This is controlled by effective_io_concurrency.
jjanes's user avatar
  • 40k
1 vote

Limiting user access by subnet to Amazon Aurora PostgreSQL

here are two ideas that can be tried.. Run a script or other little app in the background that scans through the killing connections that do not match the established rules it fires off every few ...
zsheep's user avatar
  • 898
1 vote
Accepted

MySQL 5.7 on AWS will not start, and then keeps trying to restart

Check there isn't another mysqld instance running. If there isn't, delete /var/lib/mysql/mysql.sock.lock and start again.
danblack's user avatar
  • 7,789
1 vote
Accepted

Do I need SQS queues to store remote data in the Amazon Web Services (AWS) cloud?

No SQS is not required. SQS is a publicly available service that only requires an authentication token in the request header. You can grant that using an IAM user account with security keys or if the ...
Aaron's user avatar
  • 1,771

Only top scored, non community-wiki answers of a minimum length are eligible