"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
Damian,
Also, if there have been a lot of updates to the table, you may need to run a
REINDEX on it. An attenuated index would be slow to load because of the
nummber of empty disk blocks.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast
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 con
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 inde
