I have used Redhsift in production for many years. Not my first choice, but great if someone is willing to pay.
It was froked from Redshift by some other company. AWS bought that and enhanced/integrated it with the rest of their products. As usual they did a good job.
It is really good technology, and no you cannot achieve the same with Postgres (as other comments are implying in this thread). As long as you have the money and read the fine manual, it will solve a lot of data problems at scale, with flexibility.
OTOH, An enitre thread could be written about AWS pricing strategy... I guess they don't have to worry about that themsleves.
Very few, if any, jokes are appropriate worldwide. If that is so, then what is the importance of this message? Should we stop making any jokes?
Nothing is acceptable in all contexts. And most things are acceptable in some context. Letting the author of the fucking code decide is one of the better ways to decide. My code, my choice!
I thought that everybody in the UK with a TV set is already paying for the BBC by law (i.e. no choice). If this doesn't change then the BBC will keep producing good independent programming.
The question now is, if everything will be as before for you, why do you care if others get it for free? Is this some "justice" thing?
You don't want anybody to talk to the cops, guilty OR innocent.
This is because if only one group talks to the cops it leads to information unraveling (i.e. innocent ppl talk -> if you shutup you admit you're guilty, so you better talk and get some better treatment or whatever.)
The only way the fifth works is if it works for everybody, otherwise it's useless.
What business? Did you need any environmental approvals or construction? Did you need to make business with the government? (i.e. contracts)
Not all business are equal. Bribes are sometimes necessary, sometimes optional and sometimes useless.
To achieve this in SQL Server do this:
BEGIN TRANSACTION;
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
//update your table here
//.. wait as long as you want
COMMIT TRANSACTION;//when ready
Alternatively you can use the WITH( REPEATABLEREAD) table hint when you select (but you still have to use transactions).
There are also implicit transactions and a lot of other ways to control concurrency...
Actually there is no reason to be freaked out by their pricing. Just buy the number of instances that you need (one for example) and don't set up any auto-scaling. This way if you get slashdoted your instance will just fail as a normal server would and you will incur no charges. Also no service...
I have worked with amazon aws and with dedicated server providers. Amazon has been much faster and reliable.
Furthermore, the way to protect your life savings from a potential business failure is not through inefficient procurement practices. Just incorporate, otherwise you will be open to all kind of risks (must of it unknown to you, and uninsured)
Your exceptions are either misunderstandings (i.e. "GMO product with built-in insecticides or herbicide resistance[...] was no doubt heavily sprayed with herbicides"
I recommend "DNA: The Secret of Life" by Watson for a new perspective on GMO. It's well written and will clarify a lot of aspects about it, and other more interesting subjects.
I am not american but I always watch closely news about the gun control in the US. I don't really like that the US is heading the way of other civilised countries in this regard. I know that US bashing is popular these days(since Iraq, GWB etc.) but the reality is that the rights that people enjoy there have always been important for the rest of the world. More precisley that country has always been a beacon of hope to opressed people around the world, and a source of concern to all goverments who would take their freedoms, or continue denying them. No man is an island, no country is ever trully a hermit kingdom. As long as american citizens enjoy certain rights there is hope for every other opressed man around the world. This is especially important in lights of american rights guarantees (some of do not even exist in most countries, and others are "implict", i.e. they can be taken away when the goverment no longer considers them so) and american conviction that they have a duty to promote their ideals around the world.
I don't know if this is really that relevant to this discussion. But the point of my message to americans is that not all foreigners are "america hating/bashers". We are not all statists (even left-wingers like me). It is american conviction and courage that dragged a lot of the world out of darkness. I am from eastern europe and I know first hand what this means.
I really think it is important that you know that the right to bear arms is not just an american issue. It is a human rights issue in my view. When this right will dissapear in the US it will probably dissapear from the entire world.
If you are from the US then keep fighting for your rights. At least you are in position to defend them, or at least to have a discussion about them. Most other people don't have that choice.
The thing that determines how much work the database has to do in order to produce the results is the FROM, the WHERE and the GROUP BY, because those are the ones that determine what's going to be accessed, joined, sorted and how. The SELECT (except for the use of aggregate functions) primarily just decides what information to present from the join results and how to present it.
I don't think this is correct. The SELECT list does impact the performance of the query because if it requires un-indexed columns that are not used any other clause(WHERE, FROM) than a lookup or a table scan will be needed to retrieve the values.
This being said the only way that removing a column form the select list of a query will make it slower is if the query planner has some bugs:)
Can someone explain this? I was under the impression that having an IPv6 address is exactly like having a public IPv4 address now (if your software can handle it). That is everyone can get in/out and you can easily host your own server and stuff..
Yes I do. Maybe I'm planning a revolution. I'm not saying the government should give that information just that there may be morally justifiable reasons to seek military information. The military is not always on your side.
I see this comparison all the time when talking about the effects of the bomb. It almost seems like the bomb saved lives. It did not. The effect was 200K dead (+-). The alternative to that was not invading Japan (and millions of casualties) but not invading Japan and negotiating peace - that was the rational way out. The dead were caused by America's lack of willingness to accept anything less then unconditional surrender.
You are a surprising idiot. The way it works here (Europe) and the way the laws are probably on your side is this: when you come to a pedestrian crossing you slow down to a speed that allows you to stop the car should someone walk "into traffic". For all intents and purposes pedestrians have the right to cross first. If the visibility is so poor than you just stop the car and cross when you're confident. Otherwise if you kill/maim someone than you go to jail.
The country are different but if they trade with each other it's a time to market problem. Average Joe doesn't know the difference between TB and TiB nor does he care enough to learn. So by the time the 'standard' country comes out with it's TiB drive the consumer already has his TB drive and will not buy another (even for the small benefit that it may have). So the Tebibibibit guys will lose out constantly over time.
Also, Firefox spellchecker doesn't know about TiB:).
This argument is stupid. Speculators have a very important role in the main function of the market in a capitalism system: establishing the price. Short selling, derivatives, ethnically analysis are all very important tools used to reach that goal.
If people were forced to always go long and only for the long run that would distort the market. Sure less people would lose money but also less will win.
You can't outlaw losing money. You are not entitled to keep your money or to make a profit. The state should only help in providing equality of opportunity not equality of outcome.
The eastern front was not an inevitable defeat for the Germans. It was won not only because of the material advantages of the USSR but also because of the surprising determination of its soldiers. The war was lost (or won) at Stalingrad and that was a battle were determination to win counted most of all.
Slashdot Mirror
The internet long united, must divide; long divided, must unite. Thus it has ever been.
I have used Redhsift in production for many years. Not my first choice, but great if someone is willing to pay.
It was froked from Redshift by some other company. AWS bought that and enhanced/integrated it with the rest of their products. As usual they did a good job.
It is really good technology, and no you cannot achieve the same with Postgres (as other comments are implying in this thread). As long as you have the money and read the fine manual, it will solve a lot of data problems at scale, with flexibility.
OTOH, An enitre thread could be written about AWS pricing strategy... I guess they don't have to worry about that themsleves.
Very few, if any, jokes are appropriate worldwide. If that is so, then what is the importance of this message? Should we stop making any jokes?
Nothing is acceptable in all contexts. And most things are acceptable in some context. Letting the author of the fucking code decide is one of the better ways to decide. My code, my choice!
I thought that everybody in the UK with a TV set is already paying for the BBC by law (i.e. no choice). If this doesn't change then the BBC will keep producing good independent programming.
The question now is, if everything will be as before for you, why do you care if others get it for free? Is this some "justice" thing?
You don't want anybody to talk to the cops, guilty OR innocent.
This is because if only one group talks to the cops it leads to information unraveling (i.e. innocent ppl talk -> if you shutup you admit you're guilty, so you better talk and get some better treatment or whatever.)
The only way the fifth works is if it works for everybody, otherwise it's useless.
What business? Did you need any environmental approvals or construction? Did you need to make business with the government? (i.e. contracts)
Not all business are equal. Bribes are sometimes necessary, sometimes optional and sometimes useless.
To achieve this in SQL Server do this:
//update your table here
//.. wait as long as you want
//when ready
BEGIN TRANSACTION;
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
COMMIT TRANSACTION;
Alternatively you can use the WITH( REPEATABLEREAD) table hint when you select (but you still have to use transactions).
There are also implicit transactions and a lot of other ways to control concurrency...
Actually there is no reason to be freaked out by their pricing. Just buy the number of instances that you need (one for example) and don't set up any auto-scaling. This way if you get slashdoted your instance will just fail as a normal server would and you will incur no charges. Also no service...
I have worked with amazon aws and with dedicated server providers. Amazon has been much faster and reliable.
Furthermore, the way to protect your life savings from a potential business failure is not through inefficient procurement practices. Just incorporate, otherwise you will be open to all kind of risks (must of it unknown to you, and uninsured)
Your exceptions are either misunderstandings (i.e. "GMO product with built-in insecticides or herbicide resistance[...] was no doubt heavily sprayed with herbicides"
I recommend "DNA: The Secret of Life" by Watson for a new perspective on GMO. It's well written and will clarify a lot of aspects about it, and other more interesting subjects.
I am not american but I always watch closely news about the gun control in the US. I don't really like that the US is heading the way of other civilised countries in this regard. I know that US bashing is popular these days(since Iraq, GWB etc.) but the reality is that the rights that people enjoy there have always been important for the rest of the world. More precisley that country has always been a beacon of hope to opressed people around the world, and a source of concern to all goverments who would take their freedoms, or continue denying them. No man is an island, no country is ever trully a hermit kingdom. As long as american citizens enjoy certain rights there is hope for every other opressed man around the world. This is especially important in lights of american rights guarantees (some of do not even exist in most countries, and others are "implict", i.e. they can be taken away when the goverment no longer considers them so) and american conviction that they have a duty to promote their ideals around the world.
I don't know if this is really that relevant to this discussion. But the point of my message to americans is that not all foreigners are "america hating/bashers". We are not all statists (even left-wingers like me). It is american conviction and courage that dragged a lot of the world out of darkness. I am from eastern europe and I know first hand what this means.
I really think it is important that you know that the right to bear arms is not just an american issue. It is a human rights issue in my view. When this right will dissapear in the US it will probably dissapear from the entire world.
If you are from the US then keep fighting for your rights. At least you are in position to defend them, or at least to have a discussion about them. Most other people don't have that choice.
Mod parent up. I know a company that does this and it is really convenient. You want some software? Go to a web site, download, get key, install.
Actually in the case of EC2 the smart thing would have been to have your instances spread over different availability zones...
feeding the troll: http://math.ucr.edu/home/baez/physics/Relativity/GR/grav_speed.html
The thing that determines how much work the database has to do in order to produce the results is the FROM, the WHERE and the GROUP BY, because those are the ones that determine what's going to be accessed, joined, sorted and how. The SELECT (except for the use of aggregate functions) primarily just decides what information to present from the join results and how to present it.
I don't think this is correct. The SELECT list does impact the performance of the query because if it requires un-indexed columns that are not used any other clause(WHERE, FROM) than a lookup or a table scan will be needed to retrieve the values. This being said the only way that removing a column form the select list of a query will make it slower is if the query planner has some bugs :)
you get out, nothing gets in
Can someone explain this? I was under the impression that having an IPv6 address is exactly like having a public IPv4 address now (if your software can handle it). That is everyone can get in/out and you can easily host your own server and stuff..
Yes I do. Maybe I'm planning a revolution. I'm not saying the government should give that information just that there may be morally justifiable reasons to seek military information.
The military is not always on your side.
I see this comparison all the time when talking about the effects of the bomb. It almost seems like the bomb saved lives. It did not. The effect was 200K dead (+-). The alternative to that was not invading Japan (and millions of casualties) but not invading Japan and negotiating peace - that was the rational way out. The dead were caused by America's lack of willingness to accept anything less then unconditional surrender.
You are a surprising idiot. The way it works here (Europe) and the way the laws are probably on your side is this: when you come to a pedestrian crossing you slow down to a speed that allows you to stop the car should someone walk "into traffic". For all intents and purposes pedestrians have the right to cross first. If the visibility is so poor than you just stop the car and cross when you're confident. Otherwise if you kill/maim someone than you go to jail.
The country are different but if they trade with each other it's a time to market problem. Average Joe doesn't know the difference between TB and TiB nor does he care enough to learn. So by the time the 'standard' country comes out with it's TiB drive the consumer already has his TB drive and will not buy another (even for the small benefit that it may have). So the Tebibibibit guys will lose out constantly over time.
:).
Also, Firefox spellchecker doesn't know about TiB
This argument is stupid. Speculators have a very important role in the main function of the market in a capitalism system: establishing the price. Short selling, derivatives, ethnically analysis are all very important tools used to reach that goal.
If people were forced to always go long and only for the long run that would distort the market. Sure less people would lose money but also less will win.
You can't outlaw losing money. You are not entitled to keep your money or to make a profit. The state should only help in providing equality of opportunity not equality of outcome.
It is not moral in any way. The death penalty is not moral therefore so is death by snoosnoo. But we should do it anyway.
And their allies. Of which my country was one. (Insensitive clod? :) nah.).
The eastern front was not an inevitable defeat for the Germans. It was won not only because of the material advantages of the USSR but also because of the surprising determination of its soldiers. The war was lost (or won) at Stalingrad and that was a battle were determination to win counted most of all.
Some parts of the world got unlucky. The Soviets and Americans winning the war was not good for everybody.
Exactly. I'll have to get a bumper sticker that says "in this car we obey the laws of thermodynamics".