Postgres and Open Source Experts

24x7x365 since 1997

Blog

Keys to moving forward in your life and career - making the leap to uncomfortable

Finding the right path when trying to move forward with your career can be challenging. From the difficult subject of compensation increases, to knowing when you are ready to move up in a role, to refining the skill set you have; there are many stepping stones that have to be put in place in order to successfully move forward in your career. In this article series I provide tips as …

Keys to Moving Forward In Your Life and Career - Get Out of Your Own Way

Finding the right path when trying to move forward with your career can be challenging. From the difficult subject of compensation increases, to knowing when you are ready to move up in a role, to refining the skill set you have, to truly understanding what your boss expects of you; there are many stepping stones that have to be put in place and in the right sequence in order to …

Hacking on PostgreSQL snap at Snapcraft Summit 2018

As you may know, Command Prompt, Inc. develops and maintains PostgreSQL snap packages as a service to community. If you used it, you also know that unfortunately it is not yet a drop-in replacement for DEB builds distributed via PGDG APT repository.

PostgreSQL is one of the major open source projects out there that is extremely popular with all sorts of crowds: from enthusiasts to unicorn startups. And as the …

Command Prompt Inc. Invites You to Attend InnoTech Houston

One of my favorite annual technology events takes place each October in my hometown of Austin, Texas -- Innotech Austin. I've attended for several years in support of local nonprofit groups including Chick Tech Austin and Austin Women in Technology, as well as for Command Prompt Inc. I thoroughly enjoy the networking opportunities and the professional yet relaxed atmosphere of this event. While attending and exhibiting at Innotech Austin …

Is it time for a newbie-hacker mentor for PostgreSQL.org?

At PostgresConf US 2018, Bruce Momjian, Grant Zhou, and I had a meeting to discuss potential opportunities for the Chinese PostgreSQL community to participate in the wider International community, including submitting patches to PostgreSQL.Org. Then at Postgres Open China the International Consultants Committee had a meeting to discuss more opportunities in depth. Between the two meetings there were a lot of ideas but one opportunity that was considered needs …

Went to Bejing for Postgres Open China and China Open Source, Open Source World

I spent the week of June 25th in Bejing, China with the outstanding Chinese Open Source and Postgres Communities. I was there to speak atboth Postgres Open China and the China Open Source World conferences as well as participate in a Chinese Open Source panel and the International Consultants committee meeting, of which I am the President. This was my first trip to Asia and it was amazing. The Chinese …

The 401 on Silicon Valley Postgres

August 2017

We launched the Silicon Valley Postgres Meetup.

March 6th, 2018

We have reached 401 members in what is proving to be one of the fastest growing Postgres meetups in the United States. We launched the meetup along with Vancouver B.C., Denver, Salt Lake City, and Phoenix.

Between these and other meetups we help organize such as New York, Philly, and Dallas, we are reaching more people than ever …

December 2017 Update and News

PostgreSQL V10: An Amplified Version Of PostgreSQL

For more than a decade, the Postgres community has released new major versions almost annually to meet the evolving needs of the Database Industry. The first great release of Postgres was 8.3 in 2008, with a clean and evolutionary release of 8.4 eighteen months later.
The 2017 v10 release of Postgres is the first version that Command Prompt Inc. founder and lead consultant …

Connection Initiation Overhead is Killing Your Web App - Use a Connection Pool

Customers often ask us what is the correct setting for max_connections on their PostgreSQL cluster?  There is a short answer to this question, and there is a very, very long answer. The short answer is: accept the default if that works for you, or try 10 times the number of CPU cores and see if that works ok.

There is another short answer which is: you may be asking the …

Speaking and training at PGConf Austin

I leave this Sunday for beautiful and ecclectic Austin, Tx. I will be providing the training Postgres Performance and Maintenance as well as speaking on The Power of Postgres Replication. The training is one that I give several times a year but the Replication talk is new. Although I have spoke on replication before, this new presentation is all about the power of Logical Replication. If you would like to …