On Wed, 2003-09-03 at 21:32, Rudi Starcevic wrote: > Hmm ... Sorry I'm not sure then. I only use Linux with PG. > Even though it's 'brand new' you still need to Analyze so that any > Indexes etc. are built.
ANALYZE doesn't build indexes, it only updates the statistics used by the query optimizer (and in any case, "select * from <foo>" has only one reasonable query plan anyway). -Neil ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org