Richard,
And the results were?
Results are provided in bottom of the message to which you replied.
One problem at a time. Let's get the pattern-matching speed problems on
your live server sorted, then we can look at different queries.
First message in this thread described the issue with query having
additional condition
AND dok.kuupaev BETWEEN '2008-11-21' AND '2008-11-21'
It seems that this problem occurs when pattern matching and BETWEEN
conditions are used in same query.
According to Scott Garey great recommendation I added
ALTER TABLE rid ALTER COLUMN toode SET STATISTICS 1000;
This fixes testcase in live server, see my other message.
Is it OK to run
ALTER TABLE rid ALTER COLUMN toode SET STATISTICS 1000
in prod database or should I try to decrease 1000 to smaller value ?
rid is big increasing table and is changed frequently, mostly by adding
rows.
Andrus.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
