a partial index where equal to the ID column, and
that sped it up cconsiderably and consistently, but this is a headache
to maintain.
Any ideas?
Thanks
Brian
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 183 8059
6 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
at 05:53:35PM +0200, Brian Modra wrote:
This table is added to in real time, at least 10 rows per second.
[. . .]
If I do a select which uses the pkey index, where equal to the ID
column, and greater than one of the values, which should return about
1500 rows, it sometimes takes 1/2