Skip to main content
1 vote
Accepted

Setting up Transactional Replication - Can i safely remove transactional replication if it is causing issues on my publisher?

Can i safely remove transactional replication if it is causing issues on my publisher? I am answering your broad question first. The answer is yes. You can follow Manually remove replication in SQL ...
SqlWorldWide's user avatar
  • 13.4k
1 vote

Designing Tables for Large Amounts of Time-Series Data

It depends on what you plan to do with the data. 20 measurements is not a lot of columns to be honest. 1 reading per minute is not that much, and billions of rows in a table isn't something to be ...
J.D.'s user avatar
  • 38.1k
1 vote

Designing Tables for Large Amounts of Time-Series Data

I will use MQTT terms: "topic" represents the unique identifier of the sensor (for example src_id, measurement_id), "timestamp" obviously, and "value" is the measurement ...
bobflux's user avatar
  • 1,551
1 vote

Designing Tables for Large Amounts of Time-Series Data

I recommend option 1. The problem with option 2 is that each table row in PostgreSQL has an overhead of at least 23 bytes apart from the data, so the tables will become much bigger. Option 3 is ...
Laurenz Albe's user avatar
  • 53.4k
1 vote

Postgres jsonb vs composite type performance differences

Edit: These tests were performed in Postgres 12.16. When I ran the queries in the selected answer against my own data, I found significantly different results. In particular, the LATERAL JOIN to ...
Robert's user avatar
  • 111

Only top scored, non community-wiki answers of a minimum length are eligible