Re: table drops - Mailing list pgsql-general

From Richard Huxton
Subject Re: table drops
Date
Msg-id 200211071642.52740.dev@archonet.com
Whole thread Raw
In response to table drops  ("Douglas Blood" <newsgroups@dblood.matraex.com>)
List pgsql-general
On Wednesday 06 Nov 2002 5:09 pm, Douglas Blood wrote:
> Does anyone know why a drop of a table takes longer than a copy out? or a
> select *? and is there any way that i could speed it up?

Do you have a lot of constraints (foreign keys and other triggers) on this
table? If so, dropping these first might well sort things out.

--
  Richard Huxton

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: parser error: 9223372036854775807
Next
From: Darko Prenosil
Date:
Subject: Re: Inquiry From Form [pgsql]