Re: [SQL] REINDEX DATABASE

2005-07-26 Thread Achilleus Mantzios
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

Re: [SQL] Joining two large tables on a tiny subset of rows

2005-07-26 Thread Gnanavel S
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-++

[SQL] Joining two large tables on a tiny subset of rows

2005-07-26 Thread Dmitri Bichko
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

Re: [SQL] REINDEX DATABASE

2005-07-26 Thread Chris Browne
[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

Re: [SQL] REINDEX DATABASE

2005-07-26 Thread Achilleus Mantzios
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

Re: [SQL] REINDEX DATABASE

2005-07-26 Thread Christopher Browne
> 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

[SQL] REINDEX DATABASE

2005-07-26 Thread Eugene E.
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 -