PostgreSQL Performance - Re: [GENERAL] Creation of tsearch2 index is very

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [GENERAL] Creation of tsearch2 index is very

Tom Lane

2006-01-21, 8:24 pm

David Lang <dlang@invendra.net> writes:
> On Sat, 21 Jan 2006, Tom Lane wrote:
[color=darkred]
> does the order of the items within a given page matter?

AFAIK the items within a GIST index page are just stored in insertion
order (which is exactly why Ron's suggestion above doesn't work well).
There's no semantic significance to it. It's only when we have to split
the page that we need to classify the items more finely.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links