"Tables" tag
Partitioning in PostgreSQL

Partitioning in PostgreSQL

Partitioning refers to splitting a large table into smaller pieces. This article covers the basics of partitioning in PostgreSQL. Currently, PostgreSQL supports range and list partitioning via table inheritance. Basically, you have to…

Better queries with MySQL

Better Queries with MySQL, Part 1

This article helps you write high-performance MySQL queries, by pointing out the various pitfalls and dangerous misconceptions that developers have. How many times have you found yourself in a situation where your Web…

All published articles are released under Creative Commons Attribution-NonCommercial 3.0 Unported License, unless otherwise noted.
Open Source For You is powered by WordPress, which gladly sits on top of a CentOS-based LEMP stack.

Creative Commons License.