ahachete

30 ms·

301.
Postgres Ibiza: A Unique, New PostgreSQL Conference(pgibz.io)
9 points by ahachete 8y ago|0 comments
302.
by ahachete 8y ago
That's really cool! But why don't you contribute back this code to pgbouncer? :)
303.
MDB (MongoDB) down by 13% after Amazon announced compatible service(nasdaq.com)
2 points by ahachete 8y ago|1 comments
304.
by ahachete 8y ago
I agree with you. Having said that, when we were working on https://www.torodb.com we discussed how we'd implement the oplog. And actually, based on PostgreSQL's logical decoding (LD), it wouldn't have been a grea
305.
by ahachete 8y ago
Corollary: PostgreSQL is also web-scale! ;P
306.
by ahachete 8y ago
That would make the internal representation used an "API" and thus won't be able to change it in the future. Apparently, they are using a 1:1 mapping between a collection and a table. Either by flattening the document or by u
307.
by ahachete 8y ago
My bet is that it is built on top of Aurora PostgreSQL. By looking at the "Limits" section ( https://docs.aws.amazon.com/documentdb/latest/developerguide... ), identifiers are limited to 63 characters and
308.
by ahachete 9y ago
My feedback: - 1.6M documents. This is a tiny dataset. I bet it's much smaller than RAM size (122GB), which means all data is in memory. Interesting benchmark, but not what I'd typically expect for a database (data size >> R
309.
by ahachete 9y ago
pgconf.eu it wasn't recorded. HighLoad++ it was, but I think not published yet.
310.
by ahachete 9y ago
It's a WIP. It's coming, stay tuned... (yo may subscribe to get noticed).
311.
by ahachete 9y ago
For those interested in postgresql.conf tuning, I did a recent presentation at two conferences recently, hope it's interesting. Slides: https://speakerdeck.com/ongres/postgresql-configuration-for-... [shamless plu
312.
by ahachete 9y ago
Because it did matter in 1978, there's a law that says that 1-O voting cannot happen, it's illegal. Only all Spaniards can vote regarding the integrity and sovereignty of Spain. If you think 1978's Constitution was approved u
313.
by ahachete 9y ago
Let's get the political reasoning straight. Under Spanish Constitution, supreme law in Spain, the right to determine the territory of Spain belongs to all Spaniards (article 2). What some people claim as "democracy" or &quo
314.
by ahachete 9y ago
That people has self-determination rights based on allegedly cultural and historic reasons is very weak point, and ignores the rule of law. But what is more worrisome is that it ignores the rights of the other group. What about the Spanish,
315.
by ahachete 9y ago
In 2013 I co-founded an experiment with a similar goal: test the maximum number of tables (empty tables, btw) that you could create on a PostgreSQL database. The answer lies in the "Billion Tables Project" :) https://ww
316.
by ahachete 9y ago
You should really read this: https://www.slideshare.net/MarkusWinand/p2d2-pagination-done...
317.
PostgreSQL 10 Beta 1 Released(postgresql.org)
507 points by ahachete 9y ago|166 comments
318.
by ahachete 9y ago
This is nuts! So this will make you: a) Check-in luggage you want it or not. b) Check-in your 2K€ laptop and risk it getting lost. Along with all the time required to put hardware, software and data back. Great. I won't fly unless stri
319.
by ahachete 10y ago
> - it's implicit, and you have to inspect the db and the code to understand it. Or run ToroDB Stampede [1] and look at the generated tables manually or via other tools like Schema Spy [2]. [1] https://www.torodb.com&#x2F
320.
by ahachete 10y ago
First of all, every database comes with some metadata overhead (catalog tables) which amounts to ~ 30MB. Take into account that this also may (should!) be in memory (shared_buffers) so it can become expensive. But the most significant facto
321.
by ahachete 10y ago
Thanks for the feedback. I agree sometimes myself think the same way too. In this case, it conveys a non-dangerous, powerful message: rather than having to design your DDL, and have that DDL updated every single time data with a different s
322.
by ahachete 10y ago
So far we have benchmarked situations where dataset > RAM or >> RAM. I think it is an interesting point to also analyze the case when dataset < RAM, to see how efficiently both systems manage the caches, query planning etc. Stay
323.
by ahachete 10y ago
Indeed, MongoDB BI connector v1 was based on PostgreSQL. However, they used 9.4's foreign data wrappers and since those could not push down query clauses, the connector itself introduced a significant performance degradation (on top of
324.
by ahachete 10y ago
So basically yes. ToroDB creates columns and tables on the fly. All the added columns are nullable, so the ALTER TABLE ADD COLUMN is an almost free operation in PostgreSQL. Sure, sparse tables are created. This is not a problem since nulls
325.
by ahachete 10y ago
Hi kasano. One of the most relevant use cases of ToroDB Stampede is precisely what you say, replacing MongoDB to PostgreSQL ETLs, where you have to design the schema, solve data type conflicts, maybe flatten or discard data, etc. And other
326.
by ahachete 10y ago
Hi, Álvaro here, from 8Kdata, the company behind ToroDB. Please let us know if you have any questions or comments about ToroDB. We will be happy to answer them :) Enjoy!
327.
Show HN: ToroDB Stampede: Automagical MongoDB to PostgreSQL, 100x Faster Queries(torodb.com)
43 points by ahachete 10y ago|17 comments
328.
by ahachete 10y ago
+1 for VIEW support :) I agree that the suggested method is more flexible (which means more performance in this kind of environments/problems). Mat views provide simplicity. I'd say not a must, but they may be useful for users who
329.
by ahachete 10y ago
The whole idea about the post is quite interesting. Definitely shows the high performance capabilities of the system. I really appreciate the addition of the parallel insert via INSERT ... SELECT which is quite handy. I have a question abou
330.
The conundrum of BI/aggregate queries on MongoDB(8kdata.com)
5 points by ahachete 10y ago|0 comments

More ›