Hi,
I have a problem
where a query inside a function is up to 100 times slower inside a function than
as a stand alone query run in psql.
The column
'botnumber' isa character(10), is indexed and there are 125000 rows in the
table.
Help
please!
This query is
fast:-
explain
analyze
Hi,
Has anybody got any ideas on my
recent posting ? (thanks in advance) :-
I have a problem
where a query inside a function is up to 100 times slower inside a function than
as a stand alone query run in psql.
The column
'botnumber' isa character(10), is indexed and there are 125000
Hi,
I have had some
performance problems recently on very large tables (10s of millions of
rows). A vacuum full did make a large improvement and then dropping
re-creating the indexes also was very beneficial. My performance problem
has now been solved.
My question is: will
using the
Eliminate that contention point, and you will have solved your problem.
I agree, If your updates are slow then you will get a queue building up.
Make sure that:-
1) all your indexing is optimised.
2) you are doing regular vacuuming (bloated tables will cause a slow down
due to swapping).
3)