Efficient way to remove OID data - Mailing list pgsql-performance

From James Gunzelman
Subject Efficient way to remove OID data
Date
Msg-id 9697D58F4D8FF94892AF75A0A5D8CCCC01C1ED1B@OMU-EXCH1.solutionary.com
Whole thread Raw
List 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@Solutionary.com

 

Solutionary, Inc.

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@solutionary.com.  Thank you.

 

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

 

 

 

pgsql-performance by date:

Previous
From: Hervé Piedvache
Date:
Subject: Re: Tsearch2 really slower than ilike ?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Tsearch2 really slower than ilike ?