Hi Thalis On Tue, May 31, 2016 at 3:49 PM, Thalis Kalfigkopoulos <tkalf...@gmail.com> wrote:
> Intention: to drop a database and recreate it. > Expectation: the newly created db should be empty > What happens: dropping is fast, creation is slow, and when I reconnect, > all the data objects are still there. > > Commands (tried both through command line with dropdb/createdb and through > psql) > Creation is normally slower then dropping. This is normal, as it is a more involved process, and normally an unusual one, so I suspect it's being developed thinking more on correctness and verifiability than speed. Onto the other problem. I did not see the drop commands in your examples. And neither did I see how the XXXX/YYYY data got to the first dafodb in the first place. And I saw you connect to template1. ¿ Are you aware databases in postgres are made by copying a template database ? Maybe you modified the default template database ( this tends to be template1 ) and this is the reason they are all equal ( read https://www.postgresql.org/docs/9.5/static/manage-ag-templatedbs.html , and also think newly created postgres database are never empty, they have the system catalogs inside them ). Francisco Olarte.