Mike Rylander wrote:
On 8/17/05, Manfred Koizar <[EMAIL PROTECTED]> wrote:
On Mon, 25 Jul 2005 17:50:55 -0400, Kevin Murphy
<[EMAIL PROTECTED]> wrote:
and because the number of possible search terms is so large, it
would be nice if the entire index could somehow be preloaded into memor
On 8/17/05, Manfred Koizar <[EMAIL PROTECTED]> wrote:
> On Mon, 25 Jul 2005 17:50:55 -0400, Kevin Murphy
> <[EMAIL PROTECTED]> wrote:
> > and because the number of possible search terms is so large, it
> >would be nice if the entire index could somehow be preloaded into memory
> >and encouraged to
On Mon, 25 Jul 2005 17:50:55 -0400, Kevin Murphy
<[EMAIL PROTECTED]> wrote:
> and because the number of possible search terms is so large, it
>would be nice if the entire index could somehow be preloaded into memory
>and encouraged to stay there.
Postgres does not have such a feature and I wouldn
I'm trying to speed up a query on a text column of a 14M-row table.
Uncached query times vary between 1-20 seconds (maybe more), depending
on the search
term. In between time trials I've been trying to flush the disk buffer
cache by selecting count(*) from a separate 4GB table, and times are pr
