On Thu, Jul 12, 2012 at 3:48 PM, Yan Chunlu <springrider@xxxxxxxxx> wrote: > yes the system seems overloaded, I am dealing with a simple "INSERT" but not > sure if it is normal that it took more time than the explain estimated: The estimated cost is in arbitrary units, its purpose is to compare different execution plans, not estimate time taken. So it's completely normal that it doesn't match actual time taken. Ants Aasma -- Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt Web: http://www.postgresql-support.de -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
