On Friday 29 Nov 2002 4:45 am, Rudi Starcevic wrote: > Hi, > > I think I've found what I need to know. > From techdocs.postgresql.org > > >> Every you run an INSERT, UPDATE, or DELETE on an indexed table, > > PostgreSQL must update all of the table's indexes to reflect the new > data (unlike some > > >> RDBMSs, PostgreSQL updates indexes immediately so they never get out > of synch with the data).
Yep - the ANALYSE updates the statistics the planner uses. So - you should analyse when a noticable portion of your data has changed. If you had 3000 users and batch inserted 1000 users you'd probably want to ANALYSE. -- Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
