sql

Postgres performance tuning

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 …

Postgres performance tuning Read More »

Dynamic languages troubles

I have read http://www.manageability.org/blog/stuff/chandler-failure and I think it is very danger way of exposing concepts.

In the article pointed out, the quite dead Chandler project is compared to the multi-billion Eclipse project. And then a too easy analysis is done against dynamic languages, where Java is the absolute winner.

I will try to fix some of the things said there, and to add also my two cents here :)

oracle mass table drop

Sometimes I need to build a small script to delete a huge set of tables of a schema. In Oracle is easy to do it, using the meta tables "all_tables", "all_views", and "all_sequences": select  'drop table ' || table_name || ' cascade constraints;'    from all_tables where owner='protoss' and  table_name not like 'BIN%';select  'drop view …

oracle mass table drop Read More »