Oisin Glynn wrote:
I have an issue with a select returning very slowly approx 198
seconds. I took a backup of this DB and restored it on another system
and it is returning in 28 seconds.
Windows 2000 PG Version 8.0.3 Data is inserted into the table row by
row.
Table has index on service
e
I have an issue with a select returning very slowly approx 198 seconds.
I took a backup of this DB and restored it on another system and it is
returning in 28 seconds.
Windows 2000 PG Version 8.0.3 Data is inserted into the table row by row.
Table has index on service
explain SELECT
callr
