On Thursday 21 August 2008, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > I've a large table with a pk and several smaller tables with fk > referencing to it. > > deleting from the first table is very slow. > > Not all the related fk have indexes but they are VERY small (0 to > 100 records) while the main table contain 600-800K records. > > the > explain delete p; > doesn't give any clue. > > Any hint to track down the problem?
1) Define slow. 2) Tell us what your disk subsystem consists of. 3) Are there any delete triggers on the tables? -- Alan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
