Karl Denninger <karl(at)Denninger(dot)Net> writes:
> Further, if the tables are large you want to use "vacuum analyze" to reorder
> the indices in a fashion that makes queries more efficient.
Just a side comment here: VACUUM ANALYZE has nothing whatever to do
with "reordering" indexes. What it does that a plain VACUUM does
not do is gather statistics about the table contents (minimum, maximum,
and most common value of each column, at present). These stats are then
used by the optimizer to make better planning choices. At least we'd
like to think they're better, Lord willin' an' the creek don't rise...
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Seth Banks||Date: 2000-03-07 07:22:55|
|Subject: insert default into serial fields?|
|Previous:||From: Zot O'Connor||Date: 2000-03-07 04:47:21|
|Subject: change owner of database -- answer|