Daniel Cristian Cruz wrote: > No one knows why I got "actual time=0.014..0.570 rows=30 loops=511222" > and "actual time=0.005..0.006 rows=1 loops=15158976"? You've already tried increasing the stats targets and ANALYZEing, so: Please post the output of VACUUM ANALYZE VERBOSE on the tables of interest. > I've tryied 4 times to post this message to pgsql-performance without > success... No return, even an error... Well, the message arrives. However, many people ignore anything with "Fwd:" in it in a mailing list, since it's someone lazily resending a message by clicking on the forward button thus they've probably seen the message before. -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance