Release by Winter Haven Police Department: Instead of Skip Scan - It's Skip Pay! On Thursday, the guy pictured below went to Walmart (7450 Cypress Gardens Blvd) and selected $168 worth of merchandise. He scanned all of the items at the self-checkout. Guess what? He didn't pay! He bagged his…
Release by Winter Haven Police Department: Instead of Skip Scan - It's Skip Pay! On Thursday, the guy pictured below went to Walmart (7450 Cypress Gardens Blvd) and selected $168 worth of merchandise. He scanned all of the items at the self-checkout. Guess what? He didn't pay! He bagged his…
How (and why) to become a PostgreSQL contributor timescale.com - get the latest breaking news, showbiz & celebrity photos, sport news & rumours, viral videos and top stories from timescale.com Daily Mail and Mail on Sunday newspapers.
How we made DISTINCT queries up to 8000x faster on PostgreSQL Table of contents
TimescaleDB 2.2.1, released today, includes “TimescaleDB Skip Scan”, our implementation of a technique to vastly improve query times for DISTINCT queries. Skip Scan works on PostgreSQL tables, TimescaleDB hypertables, and TimescaleDB distributed hypertables (which scale across machines in a multi-node cluster), achieving 26x-8000x faster queries in our tests.
Shout out to the engineers who worked on this feature: Sven Klemm, Joshua Lockerman, Nikhil Sontakke, and the entire team of reviewers and testers!
Finding the most recent data quickly
How many times in the last week have you used an application or queried data looking for the most recent value of something? Maybe you recently reviewed the latest stock or cryptocurrency price for each of your investments. Or, maybe you checked the latest On Base Percentage for all of your Fantasy Baseball team players.