Ostensibly this article is about the wins you can get as far as disk size is concerned by using cstore_fdw, but I can't help but notice they weren't creating any indices on this data.
By creating a simple GIN index on the regular jsonb table, you could dramatically improve those query times. So if your workload doesn't require that you do a table scan for all records then the tradeoff in terms of disk space would more than make up for the perf wins provided by the index.
Does anyone know if cstore supports creating indices of any kind, let alone GIN?
columnstore is supposed to not work with indices (although they have different types like zone-maps)
each column is stored separately on disk, so only the requested column-values are read from disk
This makes slow to select/update/delete a single row(oltp) since it needs to fetch multiple pages (for each column).
And makes it fast to do queries regarding data in big size (olap) by doing vectorized query execution and sequential-reads on disk
Like the author of the blog mentioned in this post, I too find it hard to wake up in the morning. But, so what? I don't feel pity for myself or try to blame my desire to sleep longer on a "disease". This blog post really hits the nail on the head.
That isn't an excuse to stop trying—there are things you can do that often help: a combination of correctly timed melatonin and light therapy can shift your circadian rhythm back towards normal. Nonetheless, it's an actual medical condition.
To everyone else: if you think you have this problem, do something about it. There's a healthy chance you can fix it.
And since it's easy for you to overcome that problem, it must mean everyone else who struggles with it must not be trying. It can't possibly be harder for them than for you, after all!
Unfortunately, not many -- yet. But we've got lots of customers who aren't going anywhere for a long time. I think prostitution is the only other industry that isn't really affected by depressions and the like.
You should really check it out, it's a sexy language. If you know java you'll feel right at home. I've been using it for almost five years and really love it. To me, the syntactic sugar they throw in for common little things are what really make it so nice. It's not overly verbose, enhancements on types can be amazingly powerful if you have no control over over an API, and the ability to use and pass blocks (similar to closures) are something that I hate being without when I am forced to go play in java-land.
I've wondered why I never see a gosu reference when comparing jvm languages. I was quite pleasantly surprised when I checked it out.. Looking forward to having a play in the near future.
I agree. And from what I have read/seen as far as Unity goes is that it is not ready for prime time just yet. On the other hand, Gnome 3 looks pretty awesome. Just saying.
Gnome 3 is great...if you have compatible graphics processing.
Ubuntu (and Gnome for that matter) are facing an interesting challenge there. Do you try to take Windows head on and assume your target customer is running new hardware? or do you try to keep the installed base of Linux users happy? Many of those are using Linux on older hardware precisely because it's still pretty snappy on those machines, while Windows is too bloated. It seems hard to have it both ways.
Fedora 15 with the latest updates and official NVIDIA drivers, its been my main environment for the last week with very little problem (especially considering FC15 is still Alpha).
My main gripe is the lack of preferences in the GUI, but a little google + cl fixes that.
Guidewire Software (San Mateo, CA) is looking for a half dozen or so software interns this summer. Paid, naturally, because who wants to work for free? We've got tons of fun things to work on, possibly including updating our outdated website!
By creating a simple GIN index on the regular jsonb table, you could dramatically improve those query times. So if your workload doesn't require that you do a table scan for all records then the tradeoff in terms of disk space would more than make up for the perf wins provided by the index.
Does anyone know if cstore supports creating indices of any kind, let alone GIN?