pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreindex in v8.2
3+ messages / 3 participants
[nested] [flat]
* reindex in v8.2
@ 2007-06-19 17:43 Bill Willits <bwillits@cox.net>
2007-06-19 17:52 ` Re: reindex in v8.2 Alvaro Herrera <alvherre@commandprompt.com>
2007-06-19 17:54 ` Re: reindex in v8.2 Dan Harris <fbsd@drivefaster.net>
0 siblings, 2 replies; 3+ messages in thread
From: Bill Willits @ 2007-06-19 17:43 UTC (permalink / raw)
To: pgsql-admin
Hello:
We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In our current environment (v7.3), we run a reindex operation on all tables to recover space and improve performance (we have several tables with high insert/update load - no deletes). Is it likely that the reindex will still be beneficial after the upgrade? Or has the pg code changed such that this operation is obsolete?
Thanks in advance.
Bill Willits
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: reindex in v8.2
2007-06-19 17:43 reindex in v8.2 Bill Willits <bwillits@cox.net>
@ 2007-06-19 17:52 ` Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 0 replies; 3+ messages in thread
From: Alvaro Herrera @ 2007-06-19 17:52 UTC (permalink / raw)
To: Bill Willits <bwillits@cox.net>; +Cc: pgsql-admin
Bill Willits wrote:
> Hello:
>
> We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In
> our current environment (v7.3), we run a reindex operation on all
> tables to recover space and improve performance (we have several
> tables with high insert/update load - no deletes). Is it likely that
> the reindex will still be beneficial after the upgrade? Or has the pg
> code changed such that this operation is obsolete?
The index code was improved in 7.4, but some reindexing is still needed
in (rarer) corner cases. Try getting rid of the reindex and track your
indexes sizes for a while. If you don't notice a problem you can forget
it entirely. Most people gets away without it.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: reindex in v8.2
2007-06-19 17:43 reindex in v8.2 Bill Willits <bwillits@cox.net>
@ 2007-06-19 17:54 ` Dan Harris <fbsd@drivefaster.net>
1 sibling, 0 replies; 3+ messages in thread
From: Dan Harris @ 2007-06-19 17:54 UTC (permalink / raw)
To: pgsql-admin
Bill Willits wrote:
> Hello:
>
> We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In our
> current environment (v7.3), we run a reindex operation on all tables to
> recover space and improve performance (we have several tables with high
> insert/update load - no deletes). Is it likely that the reindex will
> still be beneficial after the upgrade? Or has the pg code changed such
> that this operation is obsolete?
>
> Thanks in advance.
> Bill Willits
When you reload your dump file into 8.2, the indexes should be created fresh and
AFAIK, a reindex at that point would not gain anything for you.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-06-19 17:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-19 17:43 reindex in v8.2 Bill Willits <bwillits@cox.net>
2007-06-19 17:52 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-06-19 17:54 ` Dan Harris <fbsd@drivefaster.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox