On Tuesday 30 March 2004 20:25, Jaime Casanova wrote:
> hi all,
>
>
> i have an amd athlon with 256 ram (i know, this is not a *real* server but
> my tables are small)
Nothing wrong with it - it's what I still use as my development server.
> i'm using vb6 (win98) with pgsql-7.3.4 (rh8) trough the
Hi everyone,
I am building a query which uses a clause like "Where doc_description like
'%keyword%'". I know a normal index won't be of any use here, but since the
table in question will get fairly big, I do want to use an index.
Can anyone give me some advise on what kind of index I can use here
On Wednesday 31 March 2004 10:51, Priem, Alexander wrote:
> Hi everyone,
>
> I am building a query which uses a clause like "Where doc_description like
> '%keyword%'". I know a normal index won't be of any use here, but since the
> table in question will get fairly big, I do want to use an index.
>
On Tuesday 30 March 2004 20:25, Jaime Casanova wrote:
hi all,
>
>
> i have an amd athlon with 256 ram (i know, this is not a *real* server
but
> my tables are small)
Nothing wrong with it - it's what I still use as my development server.
> i'm using vb6 (win98) with pgsql-7.3.4 (rh8) trough the
"Jaime Casanova" <[EMAIL PROTECTED]> writes:
> There are no indexes yet, and the table is just 6 rows long so even if
> indexes exists the planner will do a seq scan. that's my whole point 63m for
> seq scan in 6 rows table is too much.
That was 63 milliseconds, according to your original post,
On 31/03/2004 16:40 Tom Lane wrote:
"Jaime Casanova" <[EMAIL PROTECTED]> writes:
> There are no indexes yet, and the table is just 6 rows long so even if
> indexes exists the planner will do a seq scan. that's my whole point
63m for
> seq scan in 6 rows table is too much.
That was 63 milliseconds,
I am building a query which uses a clause like "Where doc_description like
'%keyword%'". I know a normal index won't be of any use here, but since the
table in question will get fairly big, I do want to use an index.
Can anyone give me some advise on what kind of index I can use here? Or
shouldn't