Efficient way to remove OID data

Поиск
Список
Период
Сортировка
От James Gunzelman
Тема Efficient way to remove OID data
Дата
Msg-id 9697D58F4D8FF94892AF75A0A5D8CCCC01C1ED1B@OMU-EXCH1.solutionary.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Hervé Piedvache
Дата:
Сообщение: Re: Tsearch2 really slower than ilike ?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Tsearch2 really slower than ilike ?