Damien Dougan [EMAIL PROTECTED] writes:
Sample analyze output for an initial query:
hydradb=# explain analyze select * from pvsubscriber where actorid =
'b3432-asdas-232-Subscriber793500';
I take it pvsubscriber is a view? What's the definition of your view?
- Index Scan using
On Thursday 05 February 2004 12:13, Damien Dougan wrote:
Hi All,
I've been seeing very slow read performance on a database of 1 million
indexed subscribers, which I believe is nothing to do with the data
itself, but delays on processing the index.
If I make a random jump into the index (say
Thanks Richard.
It certainly does appear to be memory related (on a smaller data set of
250K subscribers, all accesses are 1ms).
We're going to play with increasing RAM on the machine, and applying the
optimisation levels on the page you recommended.
(We're also running on a hardware RAID