Postgres Pro
Downloads
Home   >   mailing lists

Re: index question.. - Mailing list pgsql-general

From Stephan Szabo
Subject Re: index question..
Date
Msg-id 20021113070931.R79695-100000@megazone23.bigpanda.com
Whole thread Raw
In response to index question..  ("Williams, Travis L, NPONS" <tlw@att.com>)
List pgsql-general
Tree view 
On Wed, 13 Nov 2002, Williams, Travis L, NPONS wrote:

> Do indexs need to be dropped/recreated or reindex'd or something to keep them current?

They'll stay current, but you may find that the vacuum
doesn't reclaim all of the empty space in the index in
which case you may want to reindex for space and performance
reasons.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Comparing strings with non-ASCII characters
Next
From: Stephan Szabo
Date:
Subject: Re: error: lost syncronization with server