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 …
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;' <br /> from all_tables where owner='protoss' and table_name not like 'BIN%';<br /><br />select 'drop view ' || view_name || ' ;' <br /> from all_views where owner='zerg' ;<br /> <br /> select 'drop sequence ' || sequence_name || ' ;' <br /> from all_sequences where sequence_owner='spacemarine' ;
The "BIN%" table are special temp tables of oracle. On PostgreSQL, try use PG_TABLES meta-table Happy sqlizing!
Biblio wolf has been installed in a production environment.