Tag: PostgreSQL

Comparing Pgpool-II and PgBouncer

While I was in the process of determining different HA solutions for PostgreSQL, Pgpool and PgBouncer both came into the equation on multiple occasions.  So I decided to evaluate them and determine what kind of performance they could handle.  I…

Read More >

How to Set Up REPMGR with WITNESS for PostgreSQL 10

This blog post will go over how to set up and implement repmgr which is the PostgreSQL application to manage replication between primary and replica nodes, allowing for quick and easy failover and rebuilding of replicas. For reference, all commands…

Read More >

Fix: SQL Server to PostgreSQL Linked Server Error – “Requested conversion is not supported.”

Problem: You created a linked server on SQL Server to a PostgreSQL database. You can open and navigate the linked server on SSMS up to listing the tables, but can not perform select to certain tables, returning the below errors:…

Read More >

Pythian will be at Percona Live 2019 – Join us in Austin, Texas!

Percona Live provides the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry. This…

Read More >

Log buffer #558: a carnival of vanities for DBAs

This log buffer edition overs cloud, Oracle, PostgreSQL and MySQL. Cloud On December 4, 2018 Microsoft’s Azure Database for Open Sources announced the general availability of MariaDB. This blog intends to share some guidance and best practices for alerting on…

Read More >

Log buffer #546: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and PostgreSQL.

Read More >

Why column stores?

Introduction I’ve been working with data in many forms for my entire career. During this time, I have occasionally needed to build or query existing databases to get statistical data. Traditional databases are usually designed to query specific data from…

Read More >

Log Buffer #539: A carnival of the vanities for DBAs

This Log Buffer covers Cloud, Oracle, and PostgreSQL.

Read More >

CPU utilization is not a useful metric

Once upon a time CPU utilization was quite a useful metric. Following are the output of several tools that provide CPU utilization metrics: top top reports a load of 1.66. Is this correct? No. The correct load number is probably…

Read More >

Datascape podcast episode 18 – getting to know Postgres

On the show today we welcome Álvaro Hernández, the founder of Ongress. Ongress is a database and research company where they work mainly with Postgres in the database space, developing and researching new products. They also provide professional services for…

Read More >
Page 1 of 1412345...10...Last Page »