While we're kind of on the topic of issues with MySQL, I have a couple questions about PostgreSQL that I'd like to ask/. (hell, I've got SO many questions, that I could make this into an "ask slashdot" by itself, but I'll digress)
I'm designing a personal web business (and very new to it - this is a personal endeavor) that will require hosting small files, perhaps no more than 5 megs each, but the overall byte size of the database could reach into the terrabytes potentially. I have chosen PostgreSQL over MySQL due to user opinion for it's robust nature, BSD license and solid stability. I know of the max file size of NTFS as 16 terrabytes, I believe, so is PostgreSQL capable of storing and managing terrabyte size databases effectively? Would breaking down the data into multiple databases consisting of minimal tables be better or would handling all of the data in 1 database with lots tables be best? And how many tables can a single database handle? thousands? millions?
I have books on these databases, however, none of which answer these questions. They probably assume Joe Average is making a small family site to host pictures and such.... or maybe a small corner store going e-commerce for the first time. The BIG answers are hard to come by since most forum traffic consists of "bits" of information that would require piecing together hundres of forum threads and web site data to get 1 complete answer. I hate wild goose chases. The open source community is great for information, but piecing it all together can be a real pain in the ass.
And on a really tangential side note: I'm considering IX web hosting's top plan which apparently has no size limits for data storage. Is this web host capable of handling terrabytes of someone's web business?
Noticed something unusual with a couple of rocks? Look at the big rock on the middle left, then go right of that to a large cluster of rocks. The top left side of one of those large rocks has what looks to be a hard 90 degree angle cut. I don't even know how big that rock could be either. Might be the size of a patio paver or as big as a boulder. Now I know in the laws of natural probability that it's quite possible for this to happen naturally, but.... isn't that quite eerie since most of the surrounding rocks have relatively round edges?
Actually, you should read the reviews. No not the manufacturer's review or the dealer's promo, but the customer reviews. More specifically, you should read the negative reviews. By doing so, I can sift through the idiots VS those who really do have a legitemate gripe. If after I read the gripes I have determined the product to have serious problems that I can't live with, then I choose something else.
Since Newegg weeds out negative reviews or those that list competing products, it'll only make life a little harder trying to do research on good products.
The customer reviews are what really made Newegg worth it for me. I'd hate to have this practice expand to a more serious precedent of elimination of valuable review material.
Am I the only person thinking that this is where they're going to slip in the BIOS "trusted computing" without the common person suspecting a thing because "We're uhh just making changes to the BIOS because it's outdated.... nothing to worry about... nothing to see here... it'll be better... we promise."
Granted the BIOS has needed better functionality, but... better be on your guard people.
What I did was buy 4 low RPM fans from Papst, a manually adjustable CPU fan, and a power supply with a manually adjustable fan (enermax). I use the papst fans on 100% intake, so I have lots of positive air flow. I removed one of the front panels at the top of the case, and I can feel lots of exhaust. Under full load, the CPU (p4) doesn't increase temperature too much. The case is quiet enough that I can hear myself breathing. It's very nice.
On a side note, I've experienced that with positive airflow (mine is 80% intake fans, 20% exhaust fans), the dust level inside the case is really trivial. It's a huge difference than when I used less than 50% exhaust. I've decided to make all of my airflow positive (minus the power supply) from now on.
Quiet, cool, and less dust. It's a win-win for me.
The biggest problems I have that are preventing me from getting a DLP are the bulb life and fan noise. The more I dig, the more I find out that these pricy $300 bulbs blow out VERY OFTEN, and the fan noise is quite noticeable. The bulbs get so hot you can't even touch them for 30 minutes after powerdown, however, you can't touch them anyways or the bulb will explode. Don't let the bulb get dirty either or it will explode. (so... if you can't touch the bulb because it'll explode, and you have to keep it clean by means of touching it or it will explode, then how are consumers supposed to prevent the bulb from exploding hmm?) It's madening knowing that you'd pay $3000 for such a TV only to have so many issues with it. Heck my $300 trinitron has been running like a champ for 10 years. Oh, I forgot one thing, don't turn the DLP on/off too quickly or.... you know.... the bulb will.... you know.... poof ^_^ (BTW, the exploding info comes right from the manuals.... crazy!)
"Companies worry that the easy prerelease availability of fansub versions means that the otaku class has already seen their products, and no longer need to buy anything but the must-haves."
Perhaps they companies don't understand that this is how it's SUPPOSED to work. I'm not going to shell out $250+ for a series and find out that I don't like it. Fansubbing gives me the option to see it as a whole and buy that which I really like. And just for the record, I have a WALL of anime that looks like Suncoast.
There's also the issue of market saturation VS. otaku and the "casual buyer".
If someone told me that I'd have to shell out $500 to find out if I'd like Babylon5 or not, I'd tell them to shove it!
I'd like to have a question answered. I can't seem to find data on power consumption of CPU's at certain CPU usage % rates. I'd like to know what the P4's consume at 0% to 100% on single and dual core processors. I can't believe it's full wattage the entire time. So, does anyone have any info?
The easiest solution is to get rid of the movies section in order to save the entire site. The MPAA has succeeded in blasting entire sites for just ONE section on each site. Lokitorrent could save itself by removing that section, but if they don't, then they're toast, and I personally think it's tragic to see an entire site go for one section. I had better uses for places like suprnova and the like. I could find unlicensed anime posted there that wasn't posted on either animesuki or downloadanime.
I think you're missing the point here. Freedom in genral does have one very important price, and that's responsibility. Sure you could point out those aspects of the software to the general public, but you have to ask yourself one question: with regards to the fact that leaking this information publicly could and most likely will lead to the compromise of systems using said software, is it the responsible thing to do? The common sense answer is NO. The responsible thing to do would be to privately alert the company of the security problem and perhaps documenting such to prove you warned them in case of inaction.
So... now I'll get to see twice as much or more crap on the shelves? This is a bad idea on so many levels. The programmers are just as much an integral part of the development process as the designers. When "making money" is more important than "making the game", then it's all over.
Coding overseas is a dangerous idea. Suppose outsourcing company-x creates their own backdoor into your system? I doubt every line of foreign code is checked, so how can you be sure? What if it's all part of the game's primary EXE file, and your firewall is given the OK hmm?
Makes me sick to see software companies touting security as a primary focus, and then we see all this foreign outsourcing.
I think you're right, but that's because your analysis of the spam problem is on the "defensive" side (adding anti-spam this and that to our own systems).
The solution isn't "defensive", it's "offensive". We need a new, different email system all together. I'd propose that instead of trying to re-work our existing system, we should write a new system and allow admins to add that to their servers, then allow for new email clients to be written & tested, then finally allow users to switch over to the new system, thus leaving the older one in place and more abandoned as each day passes. Eventually, we'd all be on a new system that would not allow such things like spam. Foreign countries with open relays would have no choice but to follow through otherwise their emails will constantly be rejected by the new system.
Yeah, that's a little vague, but I think a newer system that doesn't accept unknown email is the way to go, and offering a transition phase will certainly help out the best instead of just jumping right in.
it's easy to see why 2D animation is out the door. It's not a money-maker today.
Really? Don't watch much anime do ya?
But then again, what do I know; I'm only an anime club president ^_^ HOWEVER, if anyone thinks that 2D animation is not a money maker, then they're delusional. Furthermore, 2D is a beautiful, distinct style that 3D can NEVER reproduce. Am I biased? Sure, but what I stated is true.
Disney's decision will lead to their demise. It's a known fact that people have left the company because Mike Eisner is ruining Disney. Either Disney will reverse this decision after obvious results, or they will fade away. Disney was the last company I figured would make a decision like this being that they were one of the pioneers of 2D animation. Shame on them!
There's a lot of ways I guess they could inspect the shuttle for damage, but these sensors are really not going to cover the entire ship which, if they're going to do this, is what's needed. Of course, covering the entire ship is too expensive and can make sensor replacement a real pain, so why not with all the technology we have already don't we develop little pods that can deploy and do a fly-by of the ship once it's in orbit? Ever see those little jet propelled balls that were developed for space? They're really neato. They kinda look like that training ball in Star Wars. Anyhow, why not outfit them with cameras and use, say 4-8 of them on a "relative coordinate system" to the shuttle and make them do a fly-by visual? The video could be analyzed on the shuttle and on the ground. That seems like a darn good idea to me, plus they could be used in many many other ways as well like deploy them to inspect the ISS or a satelite. This would make spacewalks unnecessary until something had to be done.
Hmm... Makes me wonder if "ADV films" will have a problem with this.
I agree. The fact that the discretion of identifying spam is left up to the spammer essentially puts us right back to square one. The government has failed time and time again to give the specific requirements to control spam and other technical problems because they simply don't know what they're dealing with.
I think that ultimately, the best way to control spam is to alter the very foundation of emailing all together. It's been discussed many times before, but when in the course of our human events will we geeks as the capable people actually DO the required steps to make it happen instead of just talk about it? What's it going to take? 100 spam a day, 1000? 10,000?
I already miss vital emails because it's just too damn cumbersome to sift through it all. My ISP's spam filters are SO powerful that valid emails get filtered, thus I have to go through the filter list jst to find missed valid emails, which kind of defeats the purpose of filtering in the first place.
Next, a public statement by the makers of "E-Machines" stated the computer manufacturers plan to sue the D.O.D. on grounds of defamation. They further stated, "This name 'E-Bomb' carries a negative connotation! Our machines don't crash or blow up because of the hardware, they do that because they're running Windows!".
Next, Microsoft sues E-Machines for defamation claiming... Oh wait, they're stating the truth. Microsoft later stated that the real reason they've decided to sue E-Machines is because they think E-Machines... "shouldn't have pointed that out"...
Meaning, 'What we do has no effect, but we need to look like we're doing something useful.' And of course there _shall_ be unintended consequences, which will require yet another government "fix".
Slashdot Mirror
While we're kind of on the topic of issues with MySQL, I have a couple questions about PostgreSQL that I'd like to ask /.
(hell, I've got SO many questions, that I could make this into an "ask slashdot" by itself, but I'll digress)
I'm designing a personal web business (and very new to it - this is a personal endeavor) that will require hosting small files, perhaps no more than 5 megs each, but the overall byte size of the database could reach into the terrabytes potentially. I have chosen PostgreSQL over MySQL due to user opinion for it's robust nature, BSD license and solid stability. I know of the max file size of NTFS as 16 terrabytes, I believe, so is PostgreSQL capable of storing and managing terrabyte size databases effectively? Would breaking down the data into multiple databases consisting of minimal tables be better or would handling all of the data in 1 database with lots tables be best? And how many tables can a single database handle? thousands? millions?
I have books on these databases, however, none of which answer these questions. They probably assume Joe Average is making a small family site to host pictures and such.... or maybe a small corner store going e-commerce for the first time. The BIG answers are hard to come by since most forum traffic consists of "bits" of information that would require piecing together hundres of forum threads and web site data to get 1 complete answer. I hate wild goose chases. The open source community is great for information, but piecing it all together can be a real pain in the ass.
And on a really tangential side note: I'm considering IX web hosting's top plan which apparently has no size limits for data storage. Is this web host capable of handling terrabytes of someone's web business?
Oh, hey! My new TV has a brighter screen than my last one! Here, watch...
takes picture
scans picture
opens photoshop
select right side of image
adjust brightness/contrast +50
VOILA! Brighter! see!
I mean, wasn't it THAT obvious when you look at the images?
Noticed something unusual with a couple of rocks? Look at the big rock on the middle left, then go right of that to a large cluster of rocks. The top left side of one of those large rocks has what looks to be a hard 90 degree angle cut. I don't even know how big that rock could be either. Might be the size of a patio paver or as big as a boulder. Now I know in the laws of natural probability that it's quite possible for this to happen naturally, but.... isn't that quite eerie since most of the surrounding rocks have relatively round edges?
Actually, you should read the reviews. No not the manufacturer's review or the dealer's promo, but the customer reviews. More specifically, you should read the negative reviews. By doing so, I can sift through the idiots VS those who really do have a legitemate gripe. If after I read the gripes I have determined the product to have serious problems that I can't live with, then I choose something else.
Since Newegg weeds out negative reviews or those that list competing products, it'll only make life a little harder trying to do research on good products.
The customer reviews are what really made Newegg worth it for me. I'd hate to have this practice expand to a more serious precedent of elimination of valuable review material.
Am I the only person thinking that this is where they're going to slip in the BIOS "trusted computing" without the common person suspecting a thing because "We're uhh just making changes to the BIOS because it's outdated.... nothing to worry about... nothing to see here... it'll be better... we promise."
Granted the BIOS has needed better functionality, but... better be on your guard people.
Wait... didn't the Voyager anomaly have something to do with a LARGE ENERGY CLOUD?!!
What I did was buy 4 low RPM fans from Papst, a manually adjustable CPU fan, and a power supply with a manually adjustable fan (enermax). I use the papst fans on 100% intake, so I have lots of positive air flow. I removed one of the front panels at the top of the case, and I can feel lots of exhaust. Under full load, the CPU (p4) doesn't increase temperature too much. The case is quiet enough that I can hear myself breathing. It's very nice.
On a side note, I've experienced that with positive airflow (mine is 80% intake fans, 20% exhaust fans), the dust level inside the case is really trivial. It's a huge difference than when I used less than 50% exhaust. I've decided to make all of my airflow positive (minus the power supply) from now on.
Quiet, cool, and less dust. It's a win-win for me.
The biggest problems I have that are preventing me from getting a DLP are the bulb life and fan noise. The more I dig, the more I find out that these pricy $300 bulbs blow out VERY OFTEN, and the fan noise is quite noticeable. The bulbs get so hot you can't even touch them for 30 minutes after powerdown, however, you can't touch them anyways or the bulb will explode. Don't let the bulb get dirty either or it will explode. (so... if you can't touch the bulb because it'll explode, and you have to keep it clean by means of touching it or it will explode, then how are consumers supposed to prevent the bulb from exploding hmm?) It's madening knowing that you'd pay $3000 for such a TV only to have so many issues with it. Heck my $300 trinitron has been running like a champ for 10 years.
Oh, I forgot one thing, don't turn the DLP on/off too quickly or.... you know.... the bulb will.... you know.... poof ^_^
(BTW, the exploding info comes right from the manuals.... crazy!)
I imagine a holographic image is all that's left of the server right about now...
"Companies worry that the easy prerelease availability of fansub versions means that the otaku class has already seen their products, and no longer need to buy anything but the must-haves."
Perhaps they companies don't understand that this is how it's SUPPOSED to work. I'm not going to shell out $250+ for a series and find out that I don't like it. Fansubbing gives me the option to see it as a whole and buy that which I really like. And just for the record, I have a WALL of anime that looks like Suncoast.
There's also the issue of market saturation VS. otaku and the "casual buyer".
If someone told me that I'd have to shell out $500 to find out if I'd like Babylon5 or not, I'd tell them to shove it!
I'd like to have a question answered.
I can't seem to find data on power consumption of CPU's at certain CPU usage % rates. I'd like to know what the P4's consume at 0% to 100% on single and dual core processors. I can't believe it's full wattage the entire time. So, does anyone have any info?
The easiest solution is to get rid of the movies section in order to save the entire site. The MPAA has succeeded in blasting entire sites for just ONE section on each site. Lokitorrent could save itself by removing that section, but if they don't, then they're toast, and I personally think it's tragic to see an entire site go for one section. I had better uses for places like suprnova and the like. I could find unlicensed anime posted there that wasn't posted on either animesuki or downloadanime.
I think you're missing the point here. Freedom in genral does have one very important price, and that's responsibility. Sure you could point out those aspects of the software to the general public, but you have to ask yourself one question: with regards to the fact that leaking this information publicly could and most likely will lead to the compromise of systems using said software, is it the responsible thing to do? The common sense answer is NO. The responsible thing to do would be to privately alert the company of the security problem and perhaps documenting such to prove you warned them in case of inaction.
Boy! If only THAT were true!
So... now I'll get to see twice as much or more crap on the shelves? This is a bad idea on so many levels. The programmers are just as much an integral part of the development process as the designers. When "making money" is more important than "making the game", then it's all over.
Coding overseas is a dangerous idea. Suppose outsourcing company-x creates their own backdoor into your system? I doubt every line of foreign code is checked, so how can you be sure? What if it's all part of the game's primary EXE file, and your firewall is given the OK hmm?
Makes me sick to see software companies touting security as a primary focus, and then we see all this foreign outsourcing.
Or perhaps one could find a job that does not require work, and therefore come to love it ;-)
ah.... you speak of management don't you.
I think you're right, but that's because your analysis of the spam problem is on the "defensive" side (adding anti-spam this and that to our own systems). The solution isn't "defensive", it's "offensive". We need a new, different email system all together. I'd propose that instead of trying to re-work our existing system, we should write a new system and allow admins to add that to their servers, then allow for new email clients to be written & tested, then finally allow users to switch over to the new system, thus leaving the older one in place and more abandoned as each day passes. Eventually, we'd all be on a new system that would not allow such things like spam. Foreign countries with open relays would have no choice but to follow through otherwise their emails will constantly be rejected by the new system. Yeah, that's a little vague, but I think a newer system that doesn't accept unknown email is the way to go, and offering a transition phase will certainly help out the best instead of just jumping right in.
I think Ash said it best: "I could lie to you about you chances, but... you have my sympathies"
Really? Don't watch much anime do ya?
But then again, what do I know; I'm only an anime club president ^_^ HOWEVER, if anyone thinks that 2D animation is not a money maker, then they're delusional. Furthermore, 2D is a beautiful, distinct style that 3D can NEVER reproduce. Am I biased? Sure, but what I stated is true.
Disney's decision will lead to their demise. It's a known fact that people have left the company because Mike Eisner is ruining Disney. Either Disney will reverse this decision after obvious results, or they will fade away. Disney was the last company I figured would make a decision like this being that they were one of the pioneers of 2D animation. Shame on them!
There's a lot of ways I guess they could inspect the shuttle for damage, but these sensors are really not going to cover the entire ship which, if they're going to do this, is what's needed. Of course, covering the entire ship is too expensive and can make sensor replacement a real pain, so why not with all the technology we have already don't we develop little pods that can deploy and do a fly-by of the ship once it's in orbit? Ever see those little jet propelled balls that were developed for space? They're really neato. They kinda look like that training ball in Star Wars. Anyhow, why not outfit them with cameras and use, say 4-8 of them on a "relative coordinate system" to the shuttle and make them do a fly-by visual? The video could be analyzed on the shuttle and on the ground. That seems like a darn good idea to me, plus they could be used in many many other ways as well like deploy them to inspect the ISS or a satelite. This would make spacewalks unnecessary until something had to be done.
Sound like a good idea anyone?
Do not attempt to adjust your TV set... We control the horizontal... We control the vertical...
Now you owe us... fitty cent
Hmm... Makes me wonder if "ADV films" will have a problem with this.
I agree. The fact that the discretion of identifying spam is left up to the spammer essentially puts us right back to square one. The government has failed time and time again to give the specific requirements to control spam and other technical problems because they simply don't know what they're dealing with.
I think that ultimately, the best way to control spam is to alter the very foundation of emailing all together. It's been discussed many times before, but when in the course of our human events will we geeks as the capable people actually DO the required steps to make it happen instead of just talk about it? What's it going to take? 100 spam a day, 1000? 10,000?
I already miss vital emails because it's just too damn cumbersome to sift through it all. My ISP's spam filters are SO powerful that valid emails get filtered, thus I have to go through the filter list jst to find missed valid emails, which kind of defeats the purpose of filtering in the first place.
Next, a public statement by the makers of "E-Machines" stated the computer manufacturers plan to sue the D.O.D. on grounds of defamation. They further stated, "This name 'E-Bomb' carries a negative connotation! Our machines don't crash or blow up because of the hardware, they do that because they're running Windows!".
Next, Microsoft sues E-Machines for defamation claiming... Oh wait, they're stating the truth. Microsoft later stated that the real reason they've decided to sue E-Machines is because they think E-Machines... "shouldn't have pointed that out"...
;-)
So... in other words... it's like software?