Hi All,
I previously posted the following as a sequel to my SELECT DISTINCT
Performance Issue question. We would most appreciate any clue or
suggestions on how to overcome this show-stopping issue. We are using 8.0.3
on Windows.
Is it a known limitation when using a view with SELECT ... LIMI
Just read the docs in contrib/tsearch2 in the PostgreSQL distribution.
Pierre A. Fortier wrote:
I search for particular strings using regular expressions (e.g. where
column ~* $query) through a text data type column which contains notes
(some html code like bold is included).
It works but my qu
Neil Conway wrote:
> Mark Stosberg wrote:
>> I've used PQA to analyze my queries and happy overall with how they are
>> running. About 55% of the query time is going to variations of the pet
>> searching query, which seems like where it should be going. The query is
>> frequent and complex. It has
I search for particular strings using regular expressions (e.g. where
column ~* $query) through a text data type column which contains notes
(some html code like bold is included).
It works but my question is whether there would be a way to speed up
searches?
>From my limited investigation, I see
Hi,
Thanks for the advice on increasing RAM and switching to AMD processors.
To tell more about our DB: Our DB is transaction intensive. Interaction to the DB is through a web based application. Typically at any instant there are over 100 users using the application and we have customers world
On 6/13/05, Saranya Sivakumar <[EMAIL PROTECTED]> wrote:
> 2 x 2.4 Ghz Intel Xeon CPU with HT(4 virtual CPUs)
switch to amd opteron (dual cpu). for the same price you get 2x
performance - comparing to xeon boxes.
> RAM - 1GB
you'd definitelly could use more ram. the more the better.
> HDD - 3