Tag: INSERT

Feed: Planet PostgreSQL. On 2nd of April 2020, Fujii Masao committed patch: Allow pg_stat_statements to track planning statistics.   This commit makes pg_stat_statements support new GUC pg_stat_statements.track_planning. If this option is enabled, pg_stat_statements tracks the planning statistics of the statements, e.g., the number of times the statement was planned, the total time spent planning the statement, etc. This feature is useful to check the statements that it takes a long time to plan. Previously since pg_stat_statements tracked only the execution statistics, we could not use that for the purpose.   The planning and execution statistics are stored at the end ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config “ProxySQL Firewalling” using the mysql_query_rules table.You can improve a whitelist using the mysql_query_rules table, but it is difficult if you have hundreds of queries.ProxySQL 2.0.9 introduces two new tables for the firewall whitelist algorithm: Admin> SELECT name AS tables FROM main.sqlite_master WHERE type='table' AND ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . There are several ways to move data between SQL Server and MariaDB. Here we will discuss them and we will highlight some caveats. Moving Data Definition from SQL Server to MariaDB To copy an SQL Server data structures to MariaDB, one has to: Generate a CSV file from SQL Server data. Modify the syntax so that it works in MariaDB. Run the file in MariaDB. Variables That Affect DDL Statements DDL statements are affected by some server system variables. sql_mode determines the behavior of some SQL statements and expressions, including how strict ... Read More

Feed: AWS Compute Blog. Author: Rob Sutter. The AWS Toolkit for Visual Studio Code has been installed over 115,000 times since launching in July 2019. We are excited to announce toolkit support for AWS Step Functions, enabling you to define, visualize, and create your Step Functions workflows without leaving VS Code.Version 1.8 of the toolkit provides two new commands in the Command Palette to help you define and visualize your workflows. The toolkit also provides code snippets for seven different Amazon States Language (ASL) state types and additional service integrations to speed up workflow development. Automatic linting detects errors in ... Read More

Feed: Planet PostgreSQL. PostgreSQL has a rich set of indexing functionality, and there are many articles explaining the syntax, usage, and value of the index. In this article, I will write basic and useful queries to see the state of database indexes. People develop databases and after some time, when there is a demand to do changes in the architecture of software, they forget to do the previous indexes’ cleanup. This approach creates a mess and sometimes slows down the database because of too many indexes. Whenever we do an update or insert, the index will be updated along with ... Read More

Feed: Planet PostgreSQL. On 18th of March 2020, Alvaro Herrera committed patch: Enable BEFORE row-level triggers for partitioned tables   ... with the limitation that the tuple must remain in the same partition.   Reviewed-by: Ashutosh Bapat Discussion: https://postgr.es/m/20200227165158.GA2071@alvherre.pgsql So, I never made triggers on partitioned tables, so I was kinda sure that they would work anyway. So I tried: =$ CREATE TABLE users ( username text NOT NULL PRIMARY KEY, fullname text ) partition BY hash (username);   =$ CREATE TABLE users_0 partition OF users FOR VALUES WITH (modulus 2, remainder 0);   =$ CREATE TABLE users_1 partition OF ... Read More

Feed: AWS Partner Network (APN) Blog. Author: APN Partner Guest Post. By Rupesh Kothapalli, AWS Architect/DevOps Engineer at BizCloud ExpertsBy Nagesh Kunamneni, Chief Technical Officer at BizCloud ExpertsEnterprises don’t require just any data to help them improve their business decisions—they require the right kind of data. You need to ask the right questions in the right way to get the answers you’re looking for, and in a form you can use. Though it sounds simple, developing those questions for massive amounts of data can be a daunting task. To deal with this challenge, data scientists typically employ MapReduce tools like ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my MySQL workload?” is really common but cannot always be easily answered. However, there are ways to come up with an answer. This question also applies when thinking of moving to any provider, not necessarily a cloud one or DBaaS.The ProblemThe most reliable conclusion can be found if you have a testing environment that is fully identical and can produce the same amount of traffic compared to your production version. In this case, the ... Read More

Feed: Planet PostgreSQL. The plan for today was not decided until after I got out of bed. I sat down with coffee and looked through the list of tasks. I found one which appealed: monitor the cache_clearing_ports & cache_clearing_dates tables This is part one of a two-part story. The first part deals with fixing a database table before doing the planned work in part two, a Nagios check. In this post: PostgreSQL 12.2 Nagios 3.5 FreeBSD 12.1 FreshPorts stores a lot of data in the database, but caches pages on disk. Specific events clear that cache, and the two tables ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Vijay Singh. In the blog about ‘Is SQL Needed to be a Data Scientist?’, we have discussed the importance of SQL and basics of how knowledge of SQL helps with a successful data science career. In this blog, let us take that forward and discuss the same in more detail. if you have some basic knowledge of SQL and are preparing for an interview, read our list of SQL Interview Questions, which will help get you the job. However, before getting into that, it will be useful to know why and ... Read More