Hello,
I am wondering if it is possible to use several
machine as cluster to boost the slow queries. Is
that possible? Anybody have tried that before?
Initially, I was thinking to use dual CPUS instead
of one. but it is not correct because pgsql is not
multi-threaded.
Any suggestions are
Hi all,
Which one is better (performance/easier to use),
tsearch2 or fulltextindex?
there is an example how to use fulltextindex in the
techdocs, but I checked the contrib/fulltextindex
package, there is a WARNING that fulltextindex is
much slower than tsearch2. but tsearch2 seems
complex to
-
From: Neil Conway [EMAIL PROTECTED]
Date: Wednesday, November 26, 2003 10:03 pm
Subject: Re: [PERFORM] very large db performance
question
LIANHE SHAO [EMAIL PROTECTED] writes:
We will have a very large database to store
microarray data (may
exceed 80-100G some day). now we have 1G RAM, 2G
Hz
Hi all,
I want to use index on the gene_symbol column in my
query and gene_symbol is indexed. but when I use
lower (gene_symbol) like lower('%mif%'), the index
is not used. While when I change to
lower(gene_symbol) = lower('mif'), the index is used
and index scan works, but this is not what I