By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,777 Members | 1,755 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,777 IT Pros & Developers. It's quick & easy.

routine reindexing in 7.4.6/8.0?

P: n/a

What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
Is it still considered an important maintenance task? If so, how
frequently is it needed?

Ed
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ed L. wrote:
What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
Is it still considered an important maintenance task? If so, how
frequently is it needed?


7.4 at least handles a lot of the reindex issues at vacuum time.
I assume 8 does the same.

Sincerely,

Joshua D. Drake

Ed
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

P: n/a
Ed L. wrote:
What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
Is it still considered an important maintenance task? If so, how
frequently is it needed?


7.4 at least handles a lot of the reindex issues at vacuum time.
I assume 8 does the same.

Sincerely,

Joshua D. Drake

Ed
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

P: n/a
>>>>> "EL" == Ed L <pg***@bluepolka.net> writes:

EL> What is the conventional wisdom about routine reindexing with
EL> 7.4.6 and 8.0? Is it still considered an important maintenance
EL> task? If so, how frequently is it needed?

I haven't seen a need to reindex since upgrading from 7.2 to 7.4.
Under 7.2, I needed to reindex once per month or so.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: kh***@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.