Reinder Menninga wrote:
Hi,
We tried to use the new database and at first it seemed to work. But the
performance is terrible. Some queries take over 200 seconds to execute.
All constraints and indexes seems to be imported oke from the 7.4
postgres database.
For example this query took
Johannes Verelst wrote:
Hi Reinder,
SELECT
Hi all,
Thx for all the responses. I tried a few things like vacuuming the
tables and added index on insrel.rnumber. That didn't help. Specifying
the searchdir and role is always good but on most places we want to
retrieve all relations and not of just 1 role. For example to copy a
contentelement
Reinder Menninga wrote:
Hi all,
Thx for all the responses. I tried a few things like vacuuming the
tables and added index on insrel.rnumber. That didn't help. Specifying
the searchdir and role is always good but on most places we want to
retrieve all relations and not of just 1 role. For
Michiel Meeuwissen wrote:
Reinder Menninga wrote:
Hi all,
Thx for all the responses. I tried a few things like vacuuming the
tables and added index on insrel.rnumber. That didn't help. Specifying
the searchdir and role is always good but on most places we want to
retrieve all relations and
Yes perhaps postgres 8 is even worse with query plans and inherited
tables. I tried EXPLAIN ANALYZE with the slow query but it doesn't come
to an end. It ran all night and it was still not finished..
I think if we want to use postgres 8 we should do mayor changes to the
set-up such as using