John Graber

28 Flips | 1 Magazine | 1 Like | 18 Followers | @DevOpsDBA | Keep up with John Graber on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “John Graber”

12-Step Program for Performance, with Wanelo.com

Few of my readers will be familiar with Wanelo, the social shopping site, because you just aren't in its target market. But Wanelo.com is currently …

PostgreSQL Now Has Logical Decoding

A few weeks ago, Josh Berkus wrote a blog post on Why HStore2/jsonb is the most important patch of 9.4. Everybody's going to have their own opinion …

Colorizing The psql Prompt — A Guide

The shell can be a bland, boring thing to stare at day after day.<p>So we shell dwellers spend an inordinate amount of time customizing our text based …

write scalability for UPDATE operations

Yesterday, Heikki Linnakangas committed this patch:<br>commit a3115f0d9ec1ac93b82156535dc00b10172a4fe7<br>Author: Heikki Linnakangas<br>Date: Wed Mar 12 22:46:04 …

VACUUM FULL doesn't mean "VACUUM, but better"

There's a persistent belief among some users of PostgreSQL that VACUUM and VACUUM FULL do the same thing, but that VACUUM FULL does it better. If …

Blog Archive » Waiting for 9.4 – Allow BASE_BACKUP to be throttled

On 27th of February, Alvaro Herrera committed patch:<p>Showing this would be tricky, so let me just show some example command line.<p>Before I'll do that, …

How times have changed for PostgreSQL

When I started teaching PostgreSQL education courses in 2001, PostgreSQL was the ugly one in the data center. Many of the people who were learning …

Fujitsu Enhances Lineup of Vertically Integrated Database Systems - Fujitsu Global

Linux's fsync() woes are getting some attention

In two weeks, I'm headed to LSF/MM and the Linux Collaboration Summit, by invitation of some Linux kernel hackers, to discuss how the Linux kernel …

My personal SQL coding standards

Coding standards are a Good Thing. Unfortunately, most organizations don’t have much in the way of SQL coding standards, and there aren’t many …

Databases

Explaining your PostgreSQL data

I’ve written a bit before about understanding the output from EXPLAIN and EXPLAIN ANALYZE in PostgreSQL. Though understandably getting a grasp on …

Postgres Indexing - A collection of indexing tips

Even from intial reviews of my previous post on expression based indexes I received a lot of questions and feedback around many different parts of …

Postgres Indexes – Expression/Functional Indexing

Postgres is rich with options for indexing. First you’ve got a variety of types, and beyond that you can do a variety of things with each of these …

articles about database management systems and software development.

What we write<p>Blog<p>CUBRID 10.1 is now live: better, faster, strongerCUBRID 10.1 is now live: <br>better, faster, strongerNew features, improvement and …

Databases

Functions: The most widely ignored performance tweak

It happens quite frequently that people complain about stored procedure performance in PostgreSQL. In many cases the reason for bad performance can …

Databases

Loading...

Bruce Momjian: Postgres Blog

<i>Friday, November 22, 2013</i><p>As the creator of the initial major release notes, I am aware of the many changes that go into every release. What I often …

Databases

The EDB Blog

Postgres.app on Twitter: "Postgres.app has been updated to 9.2.4, and now ships with the UUID-OSSP extension. Huzzah! http://t.co/z8WH8skos4"

Add this Tweet to your website by copying the code below. Learn more<p>Add this video to your website by copying the code below. Learn more

Top 10 Reasons I like Postgres Over SQL Server

While at Waza this year, I had a chance to talk to my friend Guillaume Roques. In addition to talking about SalesForce, we took advantage of our …

Databases

Book Review — Instant PostgreSQL Backup and Restore How-to

I recently was fortunate to receive an ePub copy of “Instant PostgreSQL Backup and Restore How-to” from Packt Publishing for review. The topic …

Documentation: 9.2: Standard Unix Tools

On most Unix platforms, PostgreSQL modifies its command title as reported by ps, so that individual server processes can readily be identified. A …

Linux

Rob Conery - Five Things You Didn't Know About PostGresSQL

Using array_agg in Postgres – powerful and flexible

In almost any application it’s common to want to aggregate some set of values together, commonly in a comma separated form. Most developers do this …

Loading...