My kneejerk reaction is that GroupBy in Postgres is just broken. This is obviously not the case, instead I just don't understand the problem it is solving. In the particular case I was trying to solve

... Postgres. #postgres #performance #exceptions #plpgsql

Let's check out how much overhead comes from Postgres' exception block usage.

Now I know you are thinking. "Could he make the title any longer?" Yes. Yes, I could. The full title should in fact be: "How to export a production Postgres database using pg_dump and then

In my previous post I explained how to delete the Universal Search database. But even with a fresh database the index process didn't stop even after running for 2 weeks. Other users reported similar problems

Universal Search is one of the most resource intensive jobs that will ever run on a Synlogy Diskstation. A full index can easily take several weeks to complete and can make a Diskstation with only 1GB

Cloud Nine C9.io has recently closed down! If you had workspaces and code there, I'll show you how to get your code out in this video. Be sure to take these steps before December 31, 2019!! There are basically

In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface! There's a reason why Postgres is so popular, find out why in this course! You have many databases to

gfx-hal 0.1发布 #gfx gfx-rs是Rust实现的底层图形抽象层，gfx-hal是gfx-rs中包含的组件，gix的硬件抽象层。不要小看这个0.1版，这是经过gfx团队2018年一年的努力，才最终发布的版本。 gfx-rs 2018 gfx-hal 又一个错误处理库: err-derive #errorhandle 该库是通过实现了过程宏为错误类型自动实现std::Error和Display。

Imagine you have a table with two date(time) columns. Typicaly start and end. Let’s say it’s a table with opening hours of shops in your city. How do you select number of hours that a shop is open for?

Queries Size statistics by table WITH table_data AS ( SELECT c.oid, nspname AS table_schema, relname AS table_name, c.reltuples::BIGINT AS rows, pg_total_relation_size(c.oid) AS total_bytes,

Hyperledger is an open source blockchain solution that you can use for setting up private blockchains. The product is becoming more useful in providing blockchain solutions to industries but there is still

PostgreSQL Introduction On this occasion, I think it is very important to share a series of tutorials about the administrator of the PostgreSQL database. Because in my opinion it is one of the best database

> rails new app_name ...gives you all you need to get started developing an application, notably using SQLite as the default datastore. I've always worked with Postgresql (postgres) since I started

Now a days when you have data, search becomes an essential part of your tool. Doesn’t matter if you have website or not, search is an important feature, which comes to mind before even starting to build

It’s not a secret that Postgres is a powerful database. After playing (some people call it using) I’ve found out that Postgres is not just amazing database but it can solve 99% of the problems you’ll

Let's cut out the chase and go straight to business! Here we gonna use the package pg Install npm install --save --save-exact pg Simple example var pg = require('pg'); // instantiate a new client // the