Tag: INDEX

Feed: Planet PostgreSQL. By Ryan Lambert -- Published November 29, 2020A few months ago I started experimenting with a few project ideas involving data over space and time. Naturally, I want to use Postgres and PostGIS as the main workhorse for these projects, the challenge was working out exactly how to pull it all together. After a couple false starts I had to put those projects aside for other priorities. In my free time I have continued working through some related reading on the topic. I found why you should be using PostGIS trajectories by Anita Graser and recommend reading ... Read More

Feed: R-bloggers. Author: Carl Howe. [This article was first published on RStudio Blog, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. This week, I’m taking a break from our regular blog content to write about some of the nitty-gritty data science we do within RStudio. Specifically, I’m going to address a question I was asked soon after joining the blogging team: Which of your blog articles received the most views in the first ... Read More

Feed: Redis Labs. Author: Andrew Brookins. When we wanted to add real-time full-text search to the Redis Labs documentation site, we turned to RediSearch. The robust search features in the RediSearch module helped us transform a bland form into an awesome search experience. To show off some of what’s possible with RediSearch and to help jumpstart your search projects, I’d like to talk about the architecture of our project and share our code. The Python application we built is called redis-sitesearch. If you want to check out the code or run it for your own site, it’s open source, and ... Read More

Feed: R-bloggers. Author: Ali. Gross domestic product (GDP) is the total monetary or market value of all the finished goods and services produced within a country’s/state’s borders in a specific time period. As a broad measure of overall domestic production, it functions as a comprehensive scorecard of a given country’s/state’s economic health. But, is this wealth and economic health distributed in a manner that can reduce the poverty and narrow the gap between the rich and the poor? Early each month, the Bureau of Labor Statistics (BLS) of the U.S. Department of Labor announces the total number of employed and unemployed ... Read More

Feed: Planet PostgreSQL. My previous blog on “PostgreSQL High Availability: Considerations and Candidates” mostly talked about defining an HA considerations for PostgreSQL, RPO and RTO and briefly touched on some of the open source solutions available. Granted that I didn’t list them all and people shared some additional ones that I may end up reviewing as well. In case you missed my previous blog, here is the link: https://www.highgo.ca/2020/08/10/postgresql-high-availability-the-considerations-and-candidates/ I think it’ll be unfair to assess the HA solutions available before laying out all core requirements and considerations. So in this blog, without discussing any particular solution, I am going ... Read More

Feed: R-bloggers. Author: Posts on R Lover ! a programmer. My last 4 posts have all focused on thevaccines being produced to fight COVID-19. They have primarily focused onBayesian methods (or at least comparing bayesian to frequentist methods). Thisone follows that pattern and provides expanded coverage of the concept ofpriors in bayesian thinking, how to operationalize them, and additionalcoverage of how to compare bayesian regression models using various tools inr. There’s no actual additional analysis of “real data”. While the news has allbeen good lately I haven’t found anything publicly available that begs forinvestigation. Instead we’ll use “realistic” but not ... Read More

Feed: Recent Announcements. Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time. RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights supports segmenting the performance data by database name. You can determine if a specific database is generating unusual high load, or is executing ... Read More

Feed: Recent Announcements. Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.   RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights supports segmenting the performance data by additional dimensions, such as database name, application, and session type. You can determine if a specific ... Read More

Feed: AWS Big Data Blog. In May 2020, we announced the general availability of real-time anomaly detection for Elasticsearch. With that release we leveraged the Random Cut Forest (RCF) algorithm to identify anomalous behaviors in the multi-dimensional data streams generated by Elasticsearch queries. We focused on aggregation first, to enable our users to quickly and accurately detect anomalies in their data streams. However, consider the example data in the following table. timestamp avg. latency region 12:00 pm 3.1 Seattle 12:00 pm 4.1 New York 12:00 pm 5.9 Berlin 12:01 pm 2.6 Seattle 12:01 pm 5.3 New York 12:01 pm 5.8 ... Read More

Feed: Planet PostgreSQL. The question was asked relatively recently on irc. And it proved to be non-trivial. Surely, if you want to have one row per category (one address per user), it's trivial – add user_id column to addresses, make it unique, and we're done. But what if we want to allow five addresses? Or five thousands? Let's see. Obviously we have to start with some table. Let's stick with addresses. Since I don't really care about other fields, it will be simple: CREATE TABLE users ( id text NOT NULL, PRIMARY KEY (id) );   INSERT INTO users (id) ... Read More