On 8/29/2011 9:44 AM, Thomas Steinmaurer wrote: > > > when i do drop table, sometime it's take hours to return (especially on > > big table) > > why ? > > Are you perhaps running the DROP TABLE statement in a transaction with > the WAIT option, while the table is in use by concurrent transactions? >
no, the database have only one client connected, the client that do the drop table ... it's not failed, it's just very very long ! as soon as it success, creating again and deleting again the table is very fast ! i thing it's connected with the number or reccord in the table (in my case lot of, and lot of index too) [Non-text portions of this message have been removed]
