pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
reindex in v8.2
3+ messages / 3 participants
[nested] [flat]

* reindex in v8.2
@ 2007-06-19 17:43  Bill Willits <bwillits@cox.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:52  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Bill Willits <bwillits@cox.net>
  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:54  Dan Harris <fbsd@drivefaster.net>
  parent: Bill Willits <bwillits@cox.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