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,
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
15 matches
Mail list logo
