Tag Archives: postgresql

SQL: One of the most valuable skills – Craig Kerstiens

Posted on February 20, 2019 by Giovanni Giorgi
I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa). Ok it is a fake. But it seems so real on these days. I was unable to avoid sleeping. I learned … Continue reading →
Posted in English Content, Structured Query Language (SQL) | Tagged , , , | Comments Off on SQL: One of the most valuable skills – Craig Kerstiens

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Posted on June 16, 2017 by Giovanni Giorgi
Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL … Continue reading →
Posted in English Content, Knowledgebase, Structured Query Language (SQL) | Tagged , , , , , , , | Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite

Postgres performance tuning

Posted on April 4, 2008 by Giovanni Giorgi
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  … Continue reading →
Posted in English Content, Knowledgebase, Legacy ObjectsRoot.com, Software, Structured Query Language (SQL) | Tagged , , | Comments Off on Postgres performance tuning

oracle mass table drop

Posted on July 3, 2007 by Giovanni Giorgi
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 || … Continue reading →
Posted in English Content, Legacy ObjectsRoot.com | Tagged , , , , , , , , , , | Comments Off on oracle mass table drop

Biblio Wolf first install

Posted on July 13, 2006 by Giovanni Giorgi
Biblio wolf has been installed in a production environment. Continue reading →
Posted in English Content, Legacy ObjectsRoot.com | Tagged , , , | Comments Off on Biblio Wolf first install