We’re rewarding the question askers & reputations are being recalculated! Read more.

New answers tagged

0

If you can tolerate a little downtime you can make a snapshot and share the snapshot with the new account. This is a simple and cheap approach though you will be down for the time it takes to make the snapshot, share and then restore it and then point your clients to the new instance. For a solution with much less downtime, if you are using RDS you can ...


0

Hi It's not about just not the number of number of session or queries which are running. Below will help you to understand how to troubleshoot this problem Download the logs from RDS console for this instance to generate the Pgbader report. Below is the format which is most suitable to generate the logs Download the pgbadger and use below command to ...


1

CREATE TABLE Table1_new LIKE Table1; INSERT INTO Table1_new SELECT * FROM Table1; ALERT TABLE Table1_new ADD COLUMN a; --slow because of big table is not optimal and has a problem. Better: CREATE TABLE Table1_new LIKE Table1; ALERT TABLE Table1_new ADD COLUMN a; -- fast because table empty INSERT INTO Table1_new SELECT *, NULL FROM Table1;...


0

As of May 2019 pgTAP is an extension in RDS postgres version 11.2, (not version 10,7 however) according to https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-postgresql-supports-minor-version-112/


1

If they have to have one from each, then the total number of distinct holdings they have, when distinction is based only on those 3 properties, must be equal to the number of "permutations" which exist: select investor_id from holdings h join securities s on (h.security_id = s.id) where market_cap in ('SM', 'MD') and country in ('CA','US') and sector ...


0

I ran into the same issue where i am not able to do any operations on the table even drop table command did not work. I am on version 8.0.17. But below option helped me. Edit data dictionary by starting mysql in debug mode. use ps -ax|grep mysqld to find the command line that was used to launch MySQL. 2013 ? Ssl /usr/sbin/mysqld stop mysql ...


2

PostgreSQL does not use threads, it uses coordinated single-thread processes. It will not use more than max_parallel_workers, system-wide, at one time. If it would exceed that, the queries will not error out, they simply run with fewer worker processes than they "wanted". If the number of connections you have trying to run queries at the same time is ...


0

This is a confirmed bug with Amazon RDS. On the "db.t2.small" MariaDB instance, it has 2GB of RAM, but innodb_buffer_pool_size is being incorrectly set to 2GB. This means MariaDB will crash when the InnoDB buffer pool fills with too much data. The temporary solution is to change the Parameter Group so: innodb_buffer_pool_instances = 12 If you want to ...


Top 50 recent answers are included