O Chris Browne έγραψε στις Jul 26, 2005 :
> [EMAIL PROTECTED] (Achilleus Mantzios) writes:
> > O Christopher Browne έγραψε στις Jul 26, 2005 :
> >
> >> > Hello
> >> >
> >> > Would you like to advice to use REINDEX DATABASE on regular basis ?
> >> >
> >> > if (yes)
> >> > how it should be connected
On 7/27/05, Dmitri Bichko <[EMAIL PROTECTED]> wrote:
Hello,I have two tables, one has a foreing key from the other (only showingthe relevant columns and indices here): Table "expresso.probes"
Column| Type |
Modifiers-++
Hello,
I have two tables, one has a foreing key from the other (only showing
the relevant columns and indices here):
Table "expresso.probes"
Column| Type | Modifiers
-++---
platform_id | integer| no
[EMAIL PROTECTED] (Achilleus Mantzios) writes:
> O Christopher Browne έγραψε στις Jul 26, 2005 :
>
>> > Hello
>> >
>> > Would you like to advice to use REINDEX DATABASE on regular basis ?
>> >
>> > if (yes)
>> > how it should be connected with VACUUM FULL ANALYZE which is run
>> > regularly ? (rei
O Christopher Browne έγραψε στις Jul 26, 2005 :
> > Hello
> >
> > Would you like to advice to use REINDEX DATABASE on regular basis ?
> >
> > if (yes)
> > how it should be connected with VACUUM FULL ANALYZE which is run
> > regularly ? (reindex before vacuum or vacuum before reindex?)
> >
> > els
> Hello
>
> Would you like to advice to use REINDEX DATABASE on regular basis ?
>
> if (yes)
> how it should be connected with VACUUM FULL ANALYZE which is run
> regularly ? (reindex before vacuum or vacuum before reindex?)
>
> else
> haw to determine _when_ to run REINDEX ?
If you are doing ordi
Hello
Would you like to advice to use REINDEX DATABASE on regular basis ?
if (yes)
how it should be connected with VACUUM FULL ANALYZE which is run
regularly ? (reindex before vacuum or vacuum before reindex?)
else
haw to determine _when_ to run REINDEX ?
many thanks
-