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
>
>
---------------------------(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
