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,

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to