On Sun, Mar 13, 2011 at 18:36, runner <run...@winning.com> wrote: > Tried removing the indexes and other constraints just for > the import but for a noob like me, this was too much to ask. Maybe > when I get more experience.
pgAdmin should make it pretty easy. Choose each index and constraint, save the code from the "SQL pane" for when you need to restore it, and do a right click -> Drop > Other than being very inefficient, and consuming > more time than necessary, is there any other down side to importing > into an indexed table? Doing so will result in somewhat larger (more bloated) indexes, but generally the performance impact of this is minimal. Regards, Marti -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
