Re: [HACKERS] analyze strangeness

2001-07-18 Thread Tom Lane
Tim Allen <[EMAIL PROTECTED]> writes: > The problem is (or was) that this analyze didn't seem to work. Queries > performed thereafter would run slowly. Doing another vacuum analyze later > on would fix this, and queries would then perform well. This makes no sense to me, either. Can you put toge

[HACKERS] analyze strangeness

2001-07-18 Thread Tim Allen
We are seeing what seems to me to be very peculiar behaviour. We have a schema upgrade script that alters the schema of an existing production database. One of the things we do is create two new indexes. The script then immediately performs a vacuum analyze. The problem is (or was) that this ana