Efficient way to remove OID data

From: "James Gunzelman" <JamesGunzelman(at)solutionary(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Efficient way to remove OID data
Date: 2004-11-16 15:57:07
Message-ID: 9697D58F4D8FF94892AF75A0A5D8CCCC01C1ED1B@OMU-EXCH1.solutionary.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have a table that has 2 columns of an OID type. I would like to issue
a truncate table command but my understanding is that the data pointed
to by the OIDs is not removed and orphaned. What would be the most
efficient way to truncate the table and not have orphaned data?

Thanks

____________________________________

Jim Gunzelman

Senior Software Engineer

phone: 402.361.3078 fax: 402.361.3100

e-mail: JamesGunzelmane(at)Solutionary(dot)com

Solutionary, Inc.

www.Solutionary.com <http://www.solutionary.com/>

Making Security Manageable 24x7

_____________________________________

Confidentiality Notice

The content of this communication, along with any attachments, is
covered by federal and state law governing electronic communications and
may contain confidential and legally privileged information. If the
reader of this message is not the intended recipient, you are hereby
notified that any dissemination, distribution, use or copying of the
information contained herein is strictly prohibited. If you have
received this communication in error, please immediately contact us by
telephone at (402) 361-3000 or e-mail security(at)solutionary(dot)com(dot) Thank
you.

Copyright 2000-2004, Solutionary, Inc. All rights reserved.
ActiveGuard, eV3, Solutionary and the Solutionary logo are registered
trademarks of Solutionary, Inc.


Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2004-11-16 16:04:28 Re: Tsearch2 really slower than ilike ?
Previous Message Hervé Piedvache 2004-11-16 15:48:11 Re: Tsearch2 really slower than ilike ?