Thread

1. Re: drop tempoary table VERY slow

   Sam Liddicott <sam.liddicott@ananova.com> — 2002-05-31T10:28:10Z

   And when I do drop a table CPU usage goes to 99% on one CPU.
    
   Sam
   
   -----Original Message-----
   From: Sam Liddicott 
   Sent: 31 May 2002 10:57
   To: 'pgsql-bugs@postgresql.org'
   Subject: drop tempoary table VERY slow
   
   
   I have a DB where this:
    
   select 1 into temporary table x;
   runs quickly, but
    
   drop table x;
    
   takes many seconds to run.
    
   I don't know why.
    
   But:
    
   begin;
   
   select 1 into temporary table x;
   abort;
    
   is very quick.
    
   Note the slow dropping applies to automatic dropping of temporary tables
   when the connection is closed.
   I now "abort" all my query sessions for speed.
    
   I cannot reproduce this on "template1" and it has not always been the case
   for my DB.
    
   Sam
    
    
     _____  
   
   
   Samuel Liddicott
   Support Consultant
   sam@ananova.com <mailto:sam@ananova.com>  
   Direct Dial: +44 (0)113 367 4523
   Fax: +44 (0)113 367 4680
   Switchboard: +44 (0)113 367 4600
   
   Ananova Limited
   Marshall Mill
   Marshall Street
   Leeds
   LS11 9YJ
   
   http://www.ananova.com
   
   Registered Office:
   St James Court
   Great Park Road
   Almondsbury Park
   Bradley Stoke
   Bristol BS32 4QJ
   Registered in England No.2858918
   
   The information transmitted is intended only for the person or entity to
   which it is addressed and may contain confidential and/or privileged
   material. Any review, retransmission, dissemination or other use of, or
   taking of any action in reliance upon, this information by persons or
   entities other than the intended recipient is prohibited. If you receive
   this in error, please contact the sender and delete the material from any
   computer.
   
    
   
   
   
   
   

2. Re: drop tempoary table VERY slow

   Andrew McMillan <andrew@catalyst.net.nz> — 2002-06-02T10:52:17Z

   On Fri, 2002-05-31 at 22:28, Sam Liddicott wrote:
   > And when I do drop a table CPU usage goes to 99% on one CPU.
   
   When did you last do a vacuum?  If you are adding and dropping temporary
   tables a lot, perhaps you should vacuum pg_class and pg_attribute often
   as well.
   
   Regards,
   					Andrew.
   >  
   > Sam
   > 
   > -----Original Message-----
   > From: Sam Liddicott 
   > Sent: 31 May 2002 10:57
   > To: 'pgsql-bugs@postgresql.org'
   > Subject: drop tempoary table VERY slow
   > 
   > 
   > I have a DB where this:
   >  
   > select 1 into temporary table x;
   > runs quickly, but
   >  
   > drop table x;
   >  
   > takes many seconds to run.
   >  
   > I don't know why.
   >  
   > But:
   >  
   > begin;
   > 
   > select 1 into temporary table x;
   > abort;
   >  
   > is very quick.
   >  
   > Note the slow dropping applies to automatic dropping of temporary tables
   > when the connection is closed.
   > I now "abort" all my query sessions for speed.
   >  
   > I cannot reproduce this on "template1" and it has not always been the case
   > for my DB.
   >  
   
   -- 
   --------------------------------------------------------------------
   Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
   WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
   DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267
          Are you enrolled at http://schoolreunions.co.nz/ yet?