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 pos
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 p
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)
Reg
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
=?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 [
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,
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 Source
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 (wi
"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 REIND
I am not sure, but it certainly makes sense that it would drop the index
on failure. I would never expect it to fail, however.
---
scott.marlowe wrote:
> Sorry, that should have been:
>
> Isn't it true that reindex's beha
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 ^
On Tue, 27 Aug 2002, Bruce Momjian wrote:
>
> REINDEX just rebuilds the index, not just drop it. In fact, 7.3 will
> have a reindexdb sc
Alvaro Herrera wrote:
> 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 dis
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 wor
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.
>
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. T
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 wit
17 matches
Mail list logo
