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.
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 ? |