Configuring work_mem in Postgres — pgMustard

One of the worst performance hits a Postgres query can take is having to perform a sort or hash operation on disk. When these space-intensive operations require more memory than is available, Postgres uses disk space instead.

12th Feb 2020

Migrating from MS SQL to PostgreSQL: Uppercase vs. Lowercase

When migrating from MS SQL to PostgreSQL, one of the first things people notice is that in MS SQL, object names such as tables and columns all appear in uppercase. While that is possible on the PostgreSQL side as well it is not really that common.

12th Feb 2020

Welcome Docs: Getting Started at Cockroach Labs

Welcome, New Roacher! That’s how all of our Welcome Documents start, though you can expect yours to start with your name on top. Welcome Docs are how we help our new teammates get started and get past the natural new job jitters at Cockroach Labs.

12th Feb 2020

How Do I Know if My PostgreSQL Backup is Good?

Backups are a must in all Disaster Recovery Plan. It might not always be enough to guarantee an acceptable Recovery Point Objective, but is a good first approach.

11th Feb 2020

Storage 101: The Language of Storage

Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.

11th Feb 2020

Performance Best Practices: Indexing

Welcome to the third in our series of blog posts covering performance best practices for MongoDB.

11th Feb 2020

How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2

This is the second installment of a two-part series on 2ndQuadrant’s repmgr, an open-source high-availability tool for PostgreSQL.

11th Feb 2020

Why Dropping a Column does not Reclaim Disk Space? (or better, why is it so fast?)

Simple answer: because PostgreSQL knows how to do its job at best!

Safeguard Your Data

Safeguarding your business and personal data has never been more difficult or more important.

PostgreSQL Performance Identifying Hot and Slow Queries

Utilizing pg_stat_statements, we’ll look at several ways to identify queries that have slow response times and queries that are heavily used.

SQL SERVER – Top Reasons for Slow Performance

Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. I had received a lot of interesting answers and perspectives on that topic. Lots of people also sent me a detailed email as they thought there is not enough space to type the answer to the question.

But the Database Worked in Development! Checking for Duplicates

As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.

How to Protect your MySQL or MariaDB Database From SQL Injection: Part One

Security is one of the most important elements of the properly designed database environment. There are numerous attack vectors used with SQL injection being probably the most popular one.

Shell Scripting Standards

The purpose of this document is to detail standards for coding shell scripts. Following these standards will help create shell scripts that are easy to read, understand, and maintain.

Queue table issues with Availability Groups in SQL Server

I recently came across an issue in a SQL Server Availability Group scenario where queries against a heavily-used queue table were taking longer and longer over time.

9th Feb 2020

The Curious Case of… restoring a table into a different database

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent.

9th Feb 2020

Distributed SQL Tips and Tricks – Feb 7, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation and blogs that have been published since the last post.

9th Feb 2020

MySQL Table can have the WASTED/FRAGMENTED space without data deletion ( DELETE ) ?

Are thinking the table fragmentation will be happened with only DELETE’s ? Do you believe the INSERT’s will also cause the table fragmentation ? Yes, INSERT’s with the ROLLBACK can also create the table fragmentation .

9th Feb 2020

The Curious Case of AUTO REST for a TABLE with an IDENTITY Column

I spent some time helping an internal web developer yesterday with the AUTO REST feature for TABLES. He needed to be able to POST up new records to a table. This TABLE was just fine, however the way it’s PRIMARY KEY was defined was causing some problems with the AUTO feature.

9th Feb 2020

#GraphCast: Neo4j 4.0 Explained in Less Than a Minute

Welcome to this week’s #GraphCast – our series featuring what you might have missed in Neo4j media from the past fortnight. Last time, our Editorial Assistant, Allison Wu, showcased our How-To video series featuring Neo4j Aura. Don’t miss that opportunity to become a Neo4j virtuoso.

9th Feb 2020

How to Identify MySQL Performance Issues with Slow Queries

Performance issues are common problems when administering MySQL databases. Sometimes these problems are, in fact, due to slow queries. In this blog, we'll deal with slow queries and how to identify these. MySQL has the capability to filter and log slow queries.

9th Feb 2020

How to Measure MySQL Performance in Kubernetes with Sysbench

As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly.

9th Feb 2020

Learn SQL: The INFORMATION_SCHEMA Database

The best way how to explain what the INFORMATION_SCHEMA database is would be – “This is the database about databases. It’s used to store details of other databases on the server”. What does that mean, how we can use it, and what we can do with this data is the topic of today’s article.

9th Feb 2020

How To Migrate From Trigger-Based Partitioning To Native in PostgreSQL

PostgreSQL 10 introduced native partitioning and more recent versions have continued to improve upon this feature. However, many people set up partition sets before native partitioning was available and would greatly benefit from migrating to it.

9th Feb 2020

Webinar 2/19: 17 Things Developers Need to Know About Databases

Most applications use databases, yet many fail to follow even the most basic best practices, resulting in poor performance, downtime, and security incidents.

9th Feb 2020

Performance Tuning Means 3 Things

And that’s it. In the grand scheme of things, those are the only 3 knobs you get.

9th Feb 2020

Different methods to attach SQL Server MDF files

This article demonstrates different methods to attach SQL Server MDF files. First, let me explain about the database files. The SQL Server database stores data in MDF files. Typically, .mdf is a preferred extension of the primary database file. It is not a type of file.

9th Feb 2020

SQL SERVER – Row Goal and Performance

During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.

First 157 158 159 160 Last