Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Relation of indices to ANALYZE
- From: Bill Moran <wmoran(at)potentialtech(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Relation of indices to ANALYZE
- Date: Thu, 17 Jul 2003 10:45:35 -0400
- Message-id: <3F16B68F.7060207@potentialtech.com> <text/plain>
Hello all, I'm putting together a database that has me wondering about the interaction of ANALYZE with indices. I guess the basic question is: are indices affected by the results of ANALYZE. The particular application I've got is doing a batch insert of lots of records. For performance, I'm dropping the indexes on the table, doing the inserts, then recreating the indexes a then doing a VACUUM ANALYZE. Specifically, I'm wondering if I should do the ANALYZE before or after I recreate the indexes, or whether it matters. Any feedbackis welcome. -- Bill Moran Potential Technologies http://www.potentialtech.com
- Follow-Ups:
- Re: Relation of indices to ANALYZE
- From: Tom Lane
- Re: Relation of indices to ANALYZE
- From: Richard Huxton
- Re: Relation of indices to ANALYZE
- Prev by Date: Re: index / sequential scan problem
- Next by Date: Re: Hardware performance
- Previous by thread: index / sequential scan problem
- Next by thread: Re: Relation of indices to ANALYZE
- Indexes: