Thread

1. Re: INSERT extremely slow with large data sets (fwd)

   George Essig <george_essig@yahoo.com> — 2003-11-14T22:02:38Z

   Slavisa Garic wrote:
   
   > Hi Everyone,
    
   > I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x 
   > onwards) 
   > and with all of them I noticed same problem with INSERTs when there is 
   > a
   > large data set. Just to so you guys can compare time it takes to insert
   > one row into a table when there are only few rows present and when 
   > there
   > are thousands:
   
   Try running VACUUM ANALYZE periodically during inserts.  I found this to help.
   
   George Essig
   
   
   

2. Re: INSERT extremely slow with large data sets (fwd)

   Slavisa Garic <slavisa.garic@infotech.monash.edu.au> — 2003-11-15T01:20:20Z

   Does VACUUM ANALYZE help with the analysis or it also speeds up the
   process. I know i could try that before I ask but experiment is running
   now and I am too curious to wait :),
   
   Anyway thanks for the hint,
   Slavisa
   
   On Fri, 14 Nov 2003, George Essig wrote:
   
   > Slavisa Garic wrote:
   > 
   > > Hi Everyone,
   >  
   > > I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x 
   > > onwards) 
   > > and with all of them I noticed same problem with INSERTs when there is 
   > > a
   > > large data set. Just to so you guys can compare time it takes to insert
   > > one row into a table when there are only few rows present and when 
   > > there
   > > are thousands:
   > 
   > Try running VACUUM ANALYZE periodically during inserts.  I found this to help.
   > 
   > George Essig
   > 
   > 
   
   
   

3. Re: INSERT extremely slow with large data sets (fwd)

   George Essig <george_essig@yahoo.com> — 2003-11-15T13:13:38Z

   --- Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au> wrote:
   > Does VACUUM ANALYZE help with the analysis or it also speeds up the
   > process. I know i could try that before I ask but experiment is running
   > now and I am too curious to wait :),
   > 
   > Anyway thanks for the hint,
   > Slavisa
   > 
   
   VACUUM ANALYZE will reclaim disk space and update statistics used by the optimizer to help execute
   queries faster.  This could speed up your inserts.  See
   http://www.postgresql.org/docs/7.3/static/sql-vacuum.html.
   
   George Essig
   
   

4. Re: INSERT extremely slow with large data sets (fwd)

   Andrew Sullivan <andrew@libertyrms.info> — 2003-11-17T14:42:43Z

   On Sat, Nov 15, 2003 at 05:13:38AM -0800, George Essig wrote:
   > 
   > VACUUM ANALYZE will reclaim disk space and update statistics used
   
   Strictly speaking, it does not reclaim disk space.  It merely marks
   it as available, assuming you have enough room in your free space
   map.  VACUUM FULL reclaims disk space, i.e. it compacts the data
   files and returns that space to the operating system.
   
   A
   -- 
   ----
   Andrew Sullivan                         204-4141 Yonge Street
   Afilias Canada                        Toronto, Ontario Canada
   <andrew@libertyrms.info>                              M2P 2A8
                                            +1 416 646 3304 x110