> Performance. Specifically, how does it compare with Mysql? Some real app comparison would be very nice.
I made some smaller tests about this. As general rules: * for complex queries, Postgres is faster. * for lot's of parallel reads/writes, Postgres is faster. * for big databases, PostgreSQL is faster. * for single and non-concurrent writes, MySQL is faster. * for simple queries and small databases, MySQL is a little bit faster.
For single writes I don't need top speed. So I don't need MySQL...;-)
One example is a Select with GROUP BY on a VARCHAR column on a table with >500000 rows. MySQL takes > 3 seconds on a MyISAM Table, locking the whole table for write access. Postgres does the same *without* lock (write access is possible) in about 2 seconds. MySQL with innodb (no locking) takes more then 10 seconds. All on the same data, same machine and comparable memory configuration.
MySQL and MyISAM is the hell when you have some expensive queries and want to write permanently to the same table or in general: when you have complex queries.
A part of the degree dissertation of mine and a friend was a censorship experiment. For this experiment we coded a proxy server, which is able to make a lot of complex manipulations, but the most effective is a simple word changer;-) Change your proxy to: proxy.odem.org:7007 and look at the live log
Oh, Anonymous Coward, you must be joking?;-)
The WDR is the organisation, who deleted a critical online article after pressure from the master of censorship.
For more infos about this see ÂEine Zensur findet doch stattÂ.
There is a lot of action against this, but most of it is, of course, in german...:)
At ODEM.org (english) we have a lot of material and infos and so on about this -- but the most are in german.
We have an online petition (Link to the english version) with more then 17000 signers, including the "internet experts" of the big political parties, the "reporters without frontier", Ian Clarke, Richard Stallman and others. You are invited to sign also...;-)
But, yes: in the public outside of the net community you hear very rarely about this. The filtering/blocking is -- if you only have a fast look on it -- against nazis! And in germeny, nearly *everyone* is against nazis.
And this is the danger: At first, they choose some Nazis. But later, there will be thousands of web sites blocked, see some quotes and infos, but the text and MP3s/OGGs are only in german.
Hi,
at ODEM.org we provide a lot of stuff to this topic:
an online petition against the planed "filter system" (don't believe that it will stop at germany's borders, after really installed) and other, provider site censorship stuff.
The banned document descibes how to stop a train without any damage to it and harm the passengers. It's not about crashing trains. The signal for the train get red and it have to stop. Thats it.
It's primary purpose is to stop trains with nuclear junk.
today I had a phone talk with Christian Schreyer, the legal advisor of Deutsche Bahn.
Deutsche Bahn will sue all, who create a mirror of this pages; if it's not possible sue them (e.g. free speech laws in the US or whatelse), they want to block the pages at the german access providers: There is a filter system in development, which will be able to block all unwanted URLs.
The stalking-horse to establish these filter system (called "Filterpilot"), which uses a combination of routing and transparent proxying, are nazi websites. Denying holocaust is illegal in germany and there is a wide front against nazis; they use this to establish filterpilot at all border gateways.
The district government of Düsseldorf, which is the outrider in the case of net censorship in germany, sais: "If we want to prohibit milk drinking, we have first test this with two milk bottles."
It is naive to think, that "Filterpilot" will remain in Germany. It's a commercial development and not only in germany there are lot if interested organisations in such a filter: remember MPAA, IPFI, Scientology,...
in germany we started an Online-Demonstration against Link-Lawsuits etc.
In Europe "Explorer" is a trademark (not of Microsoft!!!) and the owner throws lawsuits against people, which creates links to FTP-Explorer => http://www.ftpx.com (really!):-(
We started to collect signs against this and to talk to the government etc.
Slashdot Mirror
> Performance. Specifically, how does it compare with Mysql? Some real app comparison would be very nice.
... ;-)
:-( )
I made some smaller tests about this. As general rules:
* for complex queries, Postgres is faster.
* for lot's of parallel reads/writes, Postgres is faster.
* for big databases, PostgreSQL is faster.
* for single and non-concurrent writes, MySQL is faster.
* for simple queries and small databases, MySQL is a little bit faster.
For single writes I don't need top speed. So I don't need MySQL
One example is a Select with GROUP BY on a VARCHAR column on a table with >500000 rows. MySQL takes > 3 seconds on a MyISAM Table, locking the whole table for write access. Postgres does the same *without* lock (write access is possible) in about 2 seconds. MySQL with innodb (no locking) takes more then 10 seconds. All on the same data, same machine and comparable memory configuration.
MySQL and MyISAM is the hell when you have some expensive queries and want to write permanently to the same table or in general: when you have complex queries.
Ciao
Alvar, http://www.a-blast.de/statistik/ (still with MySQL
A part of the degree dissertation of mine and a friend was a censorship experiment. For this experiment we coded a proxy server, which is able to make a lot of complex manipulations, but the most effective is a simple word changer ;-) Change your proxy to: proxy.odem.org:7007 and look at the live log
Oh, Anonymous Coward, you must be joking? ;-)
The WDR is the organisation, who deleted a critical online article after pressure from the master of censorship.
For more infos about this see ÂEine Zensur findet doch stattÂ.
There is a lot of action against this, but most of it is, of course, in german ... :)
... ;-)
At ODEM.org (english) we have a lot of material and infos and so on about this -- but the most are in german.
We have an online petition (Link to the english version) with more then 17000 signers, including the "internet experts" of the big political parties, the "reporters without frontier", Ian Clarke, Richard Stallman and others. You are invited to sign also
But, yes: in the public outside of the net community you hear very rarely about this. The filtering/blocking is -- if you only have a fast look on it -- against nazis! And in germeny, nearly *everyone* is against nazis.
And this is the danger: At first, they choose some Nazis. But later, there will be thousands of web sites blocked, see some quotes and infos, but the text and MP3s/OGGs are only in german.
Hi,
at ODEM.org we provide a lot of stuff to this topic:
Uh, did you seen the new Toyota pick ups in Iraq?
They support terrorists!
Perhaps the US should make a new example in Hiroshima?
Ciao ;-)
Alvar
News on CNN: Suicide pie kills USSR nurses
The banned document descibes how to stop a train without any damage to it and harm the passengers. It's not about crashing trains. The signal for the train get red and it have to stop. Thats it.
It's primary purpose is to stop trains with nuclear junk.
Hi,
...
today I had a phone talk with Christian Schreyer, the legal advisor of Deutsche Bahn.
Deutsche Bahn will sue all, who create a mirror of this pages; if it's not possible sue them (e.g. free speech laws in the US or whatelse), they want to block the pages at the german access providers: There is a filter system in development, which will be able to block all unwanted URLs.
The stalking-horse to establish these filter system (called "Filterpilot"), which uses a combination of routing and transparent proxying, are nazi websites. Denying holocaust is illegal in germany and there is a wide front against nazis; they use this to establish filterpilot at all border gateways.
The district government of Düsseldorf, which is the outrider in the case of net censorship in germany, sais: "If we want to prohibit milk drinking, we have first test this with two milk bottles."
It is naive to think, that "Filterpilot" will remain in Germany. It's a commercial development and not only in germany there are lot if interested organisations in such a filter: remember MPAA, IPFI, Scientology,
At ODEM we have a petition against provider side filter systems. Please support us and sign the Declaration for freedom of information in the internet.
One of the most interesting things of Parrot is (at least for me), that it is a register based VM, not a stack based one.
So it seems to be really possible to code in Parrot assembler directly, optimize (Perl-) code etc.
Short answer: your friends suck.
...
Long answer: learn perl, read "Programming Perl" and you'll know if it sucks YOU or not
hi,
:-(
;)
in germany we started an Online-Demonstration against Link-Lawsuits etc.
In Europe "Explorer" is a trademark (not of Microsoft!!!) and the owner throws lawsuits against people, which creates links to FTP-Explorer => http://www.ftpx.com (really!)
We started to collect signs against this and to talk to the government etc.
you may have a look on http://www.online-demon stration.org/alink/unterschrift.html to sign or on http://www.online-demons tration.org/alink/hintergrund.html for more infos.
Sorry, the Online-Demo is german only at this time. We will create also an englosh version and the possibility to create own demonstrations. Later
Bye,
Alvar
--