Month: May 2020
SQL trickery: Configuring window functions
Generating simple data sets Before we get started, I want to introduce my favorite set-returning functions which can help you to generate sample data: All we do here is to generate a list from 1 to 10 and print it on the screen. Let us play around with window functions a bit now: There are […]
Partition management – do you really need a tool for that?
By Kaarel Moppel The functionality of using table partitions to speed up queries and make tables more manageable as data amounts grow has been available in Postgres for a long time already. Nicer declarative support became available from v10 on – so in general it’s a known technique for developers. But what is not so […]
How to count hits on a website – concurrent counting in PostgreSQL
Concurrent counting in PostgreSQL: Recently we covered “count” quite extensively in this blog. We discussed optimizing count(*) and also talked about “max(id) – min(id)” which is of course a bad idea to count data in any relational database (not just in PostgreSQL). Today I want to focus your attention on a different kind of problem […]
Binary data performance in PostgreSQL
A frequently asked question in this big data world is whether it is better to store binary data inside or outside of a PostgreSQL database. Also, since PostgreSQL has two ways of storing binary data, which one is better? I decided to benchmark the available options to have some data points next time somebody […]
PostgreSQL: Network latency does make a BIG difference
Database performance is truly important. However, when looking at performance in general people only consider the speed of SQL statements and forget the big picture. The questions now are: What is this big picture I am talking about? What is it that can make a real difference? What if not the SQL statements? More often […]
PostgreSQL: now() vs. ‘NOW’::timestamp vs. clock_timestamp()
Everybody who has ever written any kind of database application had to use time and date. However, in PostgreSQL there are some subtle issues most people might not be aware of. To make it easier for beginners, as well as advanced people, to understand this vital topic I have decided to compile some examples which […]
Series Forecasting with Recurrent Neural Networks (LSTM)
By Kevin Speyer – Hands-on time series forecasting with LSTM – This post will to teach you how to build your first Recurrent Neural Network (RNN) for series predictions. In particular, we are going to use the Long Short Term Memory (LSTM) RNN, which has gained a lot of attention in the last years. LSTM […]