tpetry

27 ms·

301.
by tpetry 5y ago
It's the cobra effect: https://en.wikipedia.org/wiki/Perverse_incentive#The_origina...
302.
by tpetry 5y ago
Are you going to open-source your optimized version?
303.
by tpetry 5y ago
But does it offer the new TimescaleDB 2.0 with all the new features? They changed their license and made all enterprise features free but only for their Community License (for self-hosting). Cloud providers are only allowed to use the fully
304.
by tpetry 5y ago
They don't let you "install" an extension, the `CREATE EXTENSION` command is just enabling an installed extension for a specific database. There are a ton more extensions than Google Cloud SQL or AWS RDS support. Both of them
305.
by tpetry 5y ago
I do host a medium-sized PostgreSQL database, but i would love not to. I need the control you won't have with a cloud offering (you can't install extensions) but i don't want to do all the other steps, and you always have the
306.
by tpetry 5y ago
How about a baby phone near your door bell and one in your office?
307.
by tpetry 5y ago
It would be really interesting reading an article on what you do different on what each part costs. Effectively how image hosting services work nowadays or if nothing changed in the past 15 years.
308.
by tpetry 5y ago
The sauce business started in the early 1980s, almost 40 years ago. A lot has changed in the last 40 years. You wouldn‘t even be able to replicate this today because of food health rules.
309.
by tpetry 5y ago
Isn‘t redpanda a reimplementation of kafka without the jvm and zookeeper? I mean how should they api compatible if they don‘t implement the same concepts.
310.
by tpetry 5y ago
Or dell forces them to buy their drives but their markup is not as high as their competitors?
311.
by tpetry 5y ago
255 characters is the default to a variable length string column in databases. So if a developer did not pay attention he just used the default which is in some cases to short for an url.
312.
by tpetry 5y ago
I guess most people have faced this. I got years ago too but after a few seconds some internal monitoring system alerted me that new ports have been exposed. I am not sure anymore how i solved it but after some time (and none of the docume
313.
by tpetry 5y ago
A cdn has a global target, there will be someone starting to work all the time around the world.
314.
by tpetry 5y ago
Can you elaborate on what they are doing?
315.
by tpetry 5y ago
But now you have the ability to merge multiple maintenance windows into one. Do for example the next 4 migrations with the view trick and the 5th is everytime applying all accumulated changes to the real tables.
316.
by tpetry 5y ago
Because AirDrop is already available on millions of Apple devices. If you start a new protocol it will only be available for a small user base and you need to ask Apple, Google and Microsoft to implement it.
317.
by tpetry 5y ago
Unlogged tables ARE NOT in memory tables. They are written to disk like every other table, but unlogged tables don‘t have use the wal and are therefore much lighter.
318.
by tpetry 5y ago
LiveWire state changes are done by simple ajax calls, no websockets are used.
319.
by tpetry 5y ago
But if your primary email provider reports an empty mailbox for the synced mailbox, the backup mailbox will be cleared too? I mean the idea is great but wouldnt you need a backup mailbox provider allowing you to restore daily snapshots?
320.
by tpetry 5y ago
What kind of read/write ratio are you using? And would your solution work for a write-heavy workload? Kafka has limits on the message size and i need a solution for storing large blobs (up to 10MB) at data ingestion on for a very short
321.
by tpetry 5y ago
That's a really interesting solution. Can you tell us more about it? Operating distributed blob storage systems is kind of fragile with every software i have yet tried.
322.
by tpetry 5y ago
Is there any stable application for this? I do have an application with varying very high and very low incoming data packets I need to save. They can be really small json documents or have larger files attached (up to 10mb). Kafka would be
323.
by tpetry 5y ago
I have not tried it but PgMustard is stating that they make the query plans more explainable and hint for the problems in your query.
324.
by tpetry 5y ago
I have been looking at patroni for years. But i still do not feel compatible using it in a production environment. If something fails it will be really really hard to fix it, but i have the same feeling for almost all these complex kubernet
325.
by tpetry 5y ago
Can you share the explain analyze output of the query?
326.
by tpetry 5y ago
MySQL has atomic ddl, which means if a ddl operation fails it is reverted. But PostgreSQL has really transactional ddl which means you can do ddl operations in a transaction and you can commit/rollback multiple ddl operations at once a
327.
by tpetry 5y ago
Hetzner has forbidden Chia yesterday too because the disk are used a lot when chia farming.
328.
by tpetry 5y ago
For every pf your examples the database will do a full table scan. If i am wrong feel free to correct me. But i tried multiple approaches more than the ones discussed and as soon as you start using random() the database will scan every reco
329.
by tpetry 5y ago
That‘s a good idea! I will play with PostGIS and assigning every record a random position on earth.
330.
by tpetry 5y ago
It‘s the best randomness that is achievable i am aware of. Do you have ideas for improvements? It‘s 2d because databases do not have kNN with index support for a single float value. And without kNN you are building approach #2 with all of i

More ›