Hello,
We are considering submitting a patch for REINDEX ALL. What syntax would
we like?
REINDEX ALL?
REINDEX DATABASE ALL?
Sincerely,
Joshua D. Drake
-- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open
Joshua D. Drake wrote:
Hello,
We are considering submitting a patch for REINDEX ALL. What syntax would
we like?
REINDEX ALL?
REINDEX DATABASE ALL?
Sincerely,
Joshua D. Drake
-- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services,
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= [EMAIL PROTECTED] writes:
What is this patch supposed to do?
As far as I can see, there is already a reindex command ...
test=# \h reindex
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
Sincerely,
Joshua D. Drake
IIRC, REINDEX DATABASE only reindexes the system catalogs. I suppose
Joshua is thinking of
Joshua D. Drake wrote:
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
RECREATE option that performs like DROP/CREATE INDEX (best without
changing the indexes OID)
On Wed, 6 Apr 2005 08:18 am, Andreas Pflug wrote:
Joshua D. Drake wrote:
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
Does this pose a problem where
Russell Smith wrote:
On Wed, 6 Apr 2005 08:18 am, Andreas Pflug wrote:
Joshua D. Drake wrote:
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
Does this
Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands?
This would be neat. Plus, it means we don't have to worry about having
unix-only script in the distro once we have Win32 support.
Actually, we should just leave the 'ALL' off. That will make them behave
like VACUUM
Christopher Kings-Lynne wrote:
Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands?
This would be neat. Plus, it means we don't have to worry about having
unix-only script in the distro once we have Win32 support.
Actually, we should just leave the 'ALL' off. That
On Tue, 27 Aug 2002, Bruce Momjian wrote:
Christopher Kings-Lynne wrote:
Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands?
This would be neat. Plus, it means we don't have to worry about having
unix-only script in the distro once we have Win32 support.
REINDEX just rebuilds the index, not just drop it. In fact, 7.3 will
have a reindexdb script.
---
scott.marlowe wrote:
On Tue, 27 Aug 2002, Bruce Momjian wrote:
Christopher Kings-Lynne wrote:
Would it be worth
On Tue, 27 Aug 2002, Bruce Momjian wrote:
Christopher Kings-Lynne wrote:
Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands?
This would be neat. Plus, it means we don't have to worry about having
unix-only script in the distro once we have Win32 support.
scott.marlowe [EMAIL PROTECTED] writes:
Sorry, that should have been:
Isn't it true that reindex's behavior ON A FAILURE is to simply, quietly
delete the index? that was reported ^
No.
If you are doing a standalone system index rebuild (with backend -P
switch) then REINDEX
Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Sorry, that should have been:
Isn't it true that reindex's behavior ON A FAILURE is to simply, quietly
delete the index? that was reported ^
No.
If you are doing a standalone system index rebuild (with backend -P
14 matches
Mail list logo