Gioorgi.com

After a bit of work, I have managed to optimize the performance of my Postgresql Server.

I have spent a saturday morning digging around Postgresql, using the fantastic komodo editor, and I am happy with the final solution.

I followed  some suggestion on power PostgreSQL site, and now my postgres is blazing fast. For small needs, tuning postgres is easy as working with MySql.
And with postgres you get for free Transaction and PL/SQL without the need to do extra configuration or tuning or your database.

The major trick is extending  the shared_buffer, and tuning the max_connections, trying to reducing it to the minimum

For tuning max_connections, remember, for instance,  10 max connections can be able to serve about 100 concurrent “real” users; this metric is not valid for robot like wget robot or similia, which generate much more traffic.

Anyway is not difficult to get a fast PostgreSQL installation “out of the box”, and the resulting database is very robust.

L’estate è proprio esplosa… per non lasciare soli soletti chi naviga su gioorgi.com a Ferragosto, eccovi un simpatico video chiamato “Vampata d’Amore”.

Lasciate i vostri commenti più sotto…

This is the first summer for Gioorgi.com.

The Editor-in-Chief has just selected a bunch of article to schedule in the next weeks.

September will be a “hot of news” month, whereas October will lead you to “new technical projects”.
Keep following (and reading) us!

Some random application ideas, for the RedScorpion section…

Inspired by the Italian Java User Group, I have done a “bet” on two simple project, to look forward them as a “projects for the user and not the technical guys”. The project are only idea at the time of writing, but if you think they can be good, leave a comment below. Bye :)
Read the rest of this entry »

We are happy to announce the first version of brasil for window, a small python backup script.

Brasil4Windows is a small python script you can use to zip and backup your files on a regular basis.
Brasil4Win offers:

• LowLoad Backup. The script will try to pause under heavy load computer.
• Fine-grained ETA using stored bytes AND passed time. It can print you a good extimation on when it will finish.
• Skip-and-retry schema for locked files. Sometimes  under windows files are locked.
  Brasil4Win retry to open them from time to time.
• Optimized for using Psyco: http://psyco.sf.net
  We suggest you to set it up psyco for on-the-fly compilation of the script. It rocks.
• The script is released under GNU Public License License v2.0, so feel free to use it.

Read the rest of this entry »