Tag: collation

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Visualizing Collations Friday, May 29, 2020 There is still significant confusion about characters sets, encodings, and collations. This is because in the real, non-digital world, we usually treat languages, their characters, and ordering as unified, but in the digital world, they are treated separately, and their distinction can be hard to visualize. These two posted queries illustrate collation in a very creative way. The first query, SELECT chr(i) FROM generate_series(1, 50000) ... Read More

Feed: AWS Public Sector Blog. Author: Rachel Van Dinter. On Dec 19, 2019, The Champagnat College Year 7 students presented their personal printed books to their families generating tears, cheers and accolades. Research shows that social emotional learning (SEL) increases student engagement at school, increases academic achievement, and helps students to be more successful in all aspects of life. FamilyBookForm, an AWS EdStart Member, aims to encourage SEL through their online book creation tool that allows K12 students to interview members of their family or community to collect spoken stories, in any language. The tool uses speech-to-text voice recognition technology ... Read More

Feed: Planet PostgreSQL. First published here . Multi-column partitioning allows us to specify more than one column as a partition key. Currently, multi-column partitioning is possible only for range and hash type. Range partitioning was introduced in PostgreSQL10 and hash partitioning was added in PostgreSQL 11. Creating Partitions To create a multi-column partition, when defining the partition key in the CREATE TABLE command, state the columns as a comma-separated list. You can specify a maximum of 32 columns. CREATE TABLE tbl_range (id int, col1 int, col2 int, col3 int) PARTITION BY RANGE (col1, col2, col3); CREATE TABLE tbl_hash (id int, col1 ... Read More

Feed: Planet PostgreSQL. Everybody who has ever written any kind of database application had to use time and date. However, in PostgreSQL there are some subtle issues most people might not be aware of. To make it easier for beginners, as well as advanced people, to understand this vital topic I have decided to compile some examples which are important for your everyday work.now() vs. ‘NOW’::timestamptzMost people are not aware of the fact that there is actually a difference between now() as a function and ‘NOW’::timestamptz as a constant. My description already contains the magic words “function” and “constant”. Why ... Read More

Feed: Planet PostgreSQL. Partitioning is one of the coolest features in the latest PostgreSQL versions.PostgreSQL 10 introduced native partitioning and more recent versions have continued to improve upon this feature.This article provides a guide to move from inheritance based partitioning to declarative partitioning, using the native features found in PostgreSQL 11+. The process itself moves the child tables, detaching them from the inheritance partition and attaching to the new declarative partitioned table. Note these instructions do not cover moving to declarative partitioning on PostgreSQL 10 since some key features that make this migration easier were not yet implemented.Also, this procedure ... Read More

Feed: Planet PostgreSQL. This is in continuation of my previous blog entry wherein I had touched upon a topic of PostgreSQL  Extensions. PostgreSQL Extensions are a plug and play set of enhancements that add an extra feature-set to a PostgreSQL cluster. Some of these features are as simple as reading or writing to an external database while others could be a sophisticated solution to implement database replication, monitoring, etc. PostgreSQL has evolved over the years from a simple open source ORDBMS to a powerful database system with over 30 years of active development offering reliability,  performance, and all ACID compliant ... Read More

Feed: Planet MySQL; Author: The Pythian Group; So, I admit the title for this post is a bit ambiguous. Not only is it the second post I’ve written in a short period of time, but it’s also focused on ProxySQL 2.0. As promised in the previous post, I’ve upgraded my testing environment to ProxySQL 2.0 and was interested to see if there are any differences in behaviour from the previous version. As it turns out, there are. In the comments section of the previous post, you’ll find a comment by ProxySQL Founder and CEO, René Cannaò: “Indeed ProxySQL doesn’t support ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure SQL Database Managed Instance were described. Its biggest selling points include nearly full compatibility with on-premises SQL Server deployments, support for SQL Server Agent, and additional security associated with its Azure virtual network integration. However, Azure SQL Database Managed Instance does not provide the same level of flexibility and agility as other Platform-as-a-Service SQL Server-based offerings in Azure. To address these shortcomings, Microsoft introduced Azure SQL Database instance pools. Before ... Read More

Feed: Planet PostgreSQL. This post is another in the packages series. It documents how the data is transformed from the raw form (pacakges_raw) into normalized data (packages). The Packages – how is this data stored? post may be useful reading. The primary purpose of this blog post is documentation of the above mentioned transformation process. Along the way I found a performance enhancement owing to a deferred constraint. That’s why this post is tagged with PostgreSQL. Some data background When data is copied into the package_raw table, two columns are left empty: abi_id port_id Those values can be determined based ... Read More

Feed: Planet PostgreSQL. While studying the WAL structure, I came across a keyword named “origin” in the WAL log that I found intriguing. There is not much details on PG official documentation on this keyword in the WAL record and its functions. Hence I set upon the research in the code to find more about this secret data, the purpose of this blog is to share my research about Origin and its purpose in the WAL log. What is Origin Based on my understanding from the codebase, the purpose of the “origin” is to stored the source of the tuple ... Read More