Thebuild.com

Thebuild. Postgresql when it's not your job 10 July 2024 Let’s say we have a database test, owned by user f that we do not want just anyone...

Today's Thebuild.com headlines: Observe fresh posts and updates on Thebuild. This site’s feed is stale or rarely updated (or it might be broken for a reason), but you may check related news or Thebuild.com popular pages instead. It is generally safe for browsing, so you may click any item to proceed to the site.

News, stories and media buzz related to Thebuild

Subscribe to related news

Tim van der Linden: Postgis, PostgreSQL's spatial partner - Part 3
via planet.postgresql

You have arrived at the final chapter of this PostGIS introduction series. Before continuing, I recommend you read chapter one and chapter two first. In the last chapter we finished by doing some real world distance measuring and we saw how different...
Aggregation queries 10x slower on MySQL compared to Postgres??
via planetmysql

How can this be? I am shocked. I have looked at query plans, confirmed indexes, checked handler status variables after query execution to figure out what MySQL is up to, and I don’t think there is anything wrong with it. MySQL is using the right...
Slow fulltext search due to wildly innacurate row estimates
via dba.stackexchange

Fulltext queries against this database (storing RT tickets) seem to be taking a very long time to execute. The attachments table (containing the fulltext data) is about 15GB. The database schema is as follows, it's about 2 million rows: I can query...
Exploring PostgreSQL temporary table explosions with Docker
via threepress

Safari Blog Safari Blog - technology, business, and design This post will detail what I learned about PostgreSQL temporary tables, how to take some preventative measures, give some examples of how to test your work using Docker, and why I cared at all...
Manually splitting a query into two queries reduces execution time by 90%. How can I force query optimizer to do the rig...
via stackoverflow

I have two queries that are entirely equivalent in their results. Method 1: Do everything in one query (takes 235 seconds) Method 2: hold intermediate data in mytemptable (total about 18 seconds) Method 2 appears to be WAY faster because it uses a...

Thebuild.com popular pages

postgresql when it's not your job

postgresql when it's not your job 10 July 2024 Let’s say we have a database test, owned by user f that we do not want just anyone to be able to execute: test=> select current_user; current_user --...