Re: table drops

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Douglas Blood" <newsgroups(at)dblood(dot)matraex(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: table drops
Date: 2002-11-07 16:42:52
Message-ID: 200211071642.52740.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • table drops at 2002-11-06 17:09:45 from Douglas Blood

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-11-07 16:51:08 Re: PostgreSQL on Linux and Solaris comparison
Previous Message Richard Huxton 2002-11-07 16:41:48 OT: mailing list delays