On Sat, Nov 19, 2005 at 09:54:23AM -0800, Craig A. James wrote:
First, I occasionally rebuild the keywords, after which the VACUUM FULL
ANALYZE takes a LONG time - like 24 hours.
You know you just need vacuum, not vacuum full, right?
Mike Stone
---(end of broadcast)-
In a recent thread, several people pointed out that UPDATE = DELETE+INSERT.
This got me to wondering.
I have a table that, roughly, looks like this:
create table doc (
id integer primary key,
document text,
keywords tsvector
);
where "keywords" has a GIST index. Th
