Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ozgune
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
22 ms
·
211.
▲
by
ozgune
13y ago
The irony is, Gul recently approved legislation that allowed the Turkish government to ban sites like Twitter. He then tweeted about his reasons for approving the new law (see his Feb 18 tweets). Now, he's tweeting saying that banning
212.
▲
by
ozgune
13y ago
Another interesting alternative could be using or writing a PostgreSQL foreign data wrapper. There is one that supports tabular data (file_fdw), and another one for JSON files (json_fdw). If you have files in other formats, you can also wri
213.
▲
by
ozgune
13y ago
Except that people weren't paying to get a Hotmail account. WhatsApp users pay $1/year, so their revenues are around that of Twitter's.
214.
▲
by
ozgune
13y ago
Congrats to the RethinkDB team! These guys rock, and I'm looking forward to their future releases.
215.
▲
by
ozgune
13y ago
For the simple wc example we used in the blog post, that could have worked. (We used this wc example to reduce the problem to its simplest form.) In practice tough, we use PostgreSQL, and we don't have any control over how Postgres rea
216.
▲
by
ozgune
13y ago
Here's my high level understanding of how Windows handles this. Windows uses a set of LRU lists to manage its page cache, where each LRU list corresponds to a priority. In its simplest form then, your pages are evicted according to an
217.
▲
by
ozgune
13y ago
My understanding is that it didn't. Prior to 2.6.31, the kernel simply used two lists. New pages were brought into the recency list, and if they were referenced for a second time, these pages were promoted to the frequency list. Simila
218.
▲
by
ozgune
13y ago
If ARC could be implemented in an efficient manner, it would. I'm guessing integrating these algorithms into existing kernel code is no small feat though. Also, ARC may need to be tweaked so that its cost doesn't become prohibitiv
219.
▲
Linux memory manager and your big data
(citusdata.com)
121 points
by
ozgune
13y ago
|
41 comments
220.
▲
by
ozgune
13y ago
That's the theory, I'll share my reality. I'm here on an L1A visa with my spouse. She quit her high paying job and followed me here after our lawyers said that getting the visa was the hard part. We have been waiting on her L
221.
▲
by
ozgune
13y ago
Yes, it's interesting that they haven't mentioned removing the need to configure SysV shared memory. In my experience, a good number of developers initially miss out on this config / kernel setting, and wonder about their per
222.
▲
Write beautiful code. Build databases / distributed systems. Join Citus Data
1 points
by
ozgune
13y ago
223.
▲
by
ozgune
13y ago
You're inferring a casual relationship from two unrelated data points across a particular year. So if I find two security violations (there's one like every other week) originating from the US across a random year, does that mean
224.
▲
by
ozgune
13y ago
I love what these guys are doing and their technology. Congrats guys!
225.
▲
by
ozgune
13y ago
I don't know how the media is governed in Singapore, but the traditional media in Turkey didn't cover the protests at all. News about the protests (could only) spread through the internet, and today I'm proud to be a techie. The Turkish Pri
226.
▲
by
ozgune
13y ago
These are the biggest protests I've seen in my lifetime, and I'm 34. People are reported wounded and dead, but no one knows how many. I called my parents in Anatolia to ask them about the protests, and they didn't know there were any. Noth
227.
▲
by
ozgune
13y ago
Thanks for the comment. Yes, that's exactly the benefit. You could in fact have heterogeneous JSON documents within one file, and json_fdw could still handle them. If a field you declared in the table schema doesn't appear in a JSON documen
228.
▲
by
ozgune
13y ago
(Ozgun at Citus Data) You're right that you need to have Postgres installed. For running SQL over multiple JSON files, we wanted to keep the blog post short and noted several different ways to go over multiple files in our GitHub Readme. 1.
229.
▲
by
ozgune
13y ago
Please also keep in mind that this blog post focuses on a workload that is completely disk I/O bound. In practice, at least part of your working set gets served from memory, and compression doesn't help with the pages that are already in me
230.
▲
by
ozgune
14y ago
(I was in the bigger engineering team at Amazon that looked into this between between '04-'08.) After having notable issues with Cisco's hardware load balancers, there was an internal project at Amazon aimed at developing scalable routing s
231.
▲
by
ozgune
14y ago
While I agree this sways me to Heroku's side, I don't think this is their marketing ploy. Rap Genius says they aren't involved either, so this is probably a single-person law firm looking to create some buzz for himself. He should threaten
232.
▲
by
ozgune
14y ago
(Ozgun @ Citus Data) Thanks for bringing this up. A lot of what we say in the FAQ for "How does CitusDB's feature set compare against Apache Hive?" also applies to Impala, and we'll update that question shortly. The fundamental difference i
233.
▲
by
ozgune
14y ago
This is a pretty interesting. I wonder how query performance differs between Redshift and local PostgreSQL for other types of benchmarks as well, say TPC-H queries. (And I guess how Redshift scales out as the dataset size increases in TPC-H
234.
▲
by
ozgune
14y ago
That's neat. :) For mongo_fdw, we're expecting better join performance once we upgrade to PostgreSQL 9.2 FDW APIs and start collecting table statistics. I'm sure there are other factors involved for MoSQL, but they are probably outside the
235.
▲
by
ozgune
14y ago
Out of curiosity, did you guys consider running SQL on MongoDB using Postgres foreign tables? What were the pros and cons of that approach for your use-cases? (In full disclosure, I wrote mongo_fdw for PostgreSQL.)
236.
▲
by
ozgune
14y ago
Well, he seems to be arguing that without an immigration reform, you may not have Google in the first place (it's getting tougher for skilled immigrants to come in): "Everyone knows that the remarkable achievements of the foreign born have
237.
▲
by
ozgune
14y ago
It took me a while to understand the extent of what these guys were up to, but I now get it. Assuming that they give you the option to store historical data, they truly are democratizing access to all the data that's out there. You can star
238.
▲
by
ozgune
14y ago
Going through the GitHub repository at firebase/firefeed right now. This looks pretty slick for 500 lines of code.
239.
▲
by
ozgune
14y ago
Hey, just updated the conclusion to clarify. Thanks for the feedback.
240.
▲
Postgres Performance: To avg or To sum/count
(citusdata.com)
27 points
by
ozgune
14y ago
|
4 comments
More ›