smiley2211 wrote:
TOP shows CPU at 100% while executed the EXPLAIN ANALYZE...what does this mean?17519 postgres 25 0 3470m 43m 39m R 100 0.3 28:50.53 postmaster
It means it's busy. Probably sorting/eliminating duplicates (see my answer posted just before this one).
Keep an eye on "vmstat" too and see if there's much disk activity. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster