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 with VACUUM FULL ANALYZE
Dmitri Bichko wrote:
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 |
[EMAIL PROTECTED] (Achilleus Mantzios) writes:
O Chris Browne έγραψε στις Jul 26, 2005 :
You can get a savings of about 4% of the space, but at the cost of
taking an appreciable outage during which the database is not usable.
1st not all database is unusable, during the whole reindexdb run,
Given a table like this:
create table primary (
a integer primary key,
b boolean
);
And another like this:
create table secondary (
a integer,
some_other_fields
);
I would like a foreign key constraint on the secondary table that
looks something like:
foreign key (a, true) references
On Wed, Jul 27, 2005 at 16:08:19 -0400,
Jeff Boes [EMAIL PROTECTED] wrote:
Given a table like this:
create table primary (
a integer primary key,
b boolean
);
And another like this:
create table secondary (
a integer,
some_other_fields
);
I would like a foreign key
Chris Browne [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Achilleus Mantzios) writes:
I am just saying that the common saying reindex is not needed for
7.4+ maybe is not true in all circumstances.
...
In versions earlier than 7.4, running a REINDEX periodically was
*essential* if you had