[PERFORM] Statistics not working??

: stats_start_collector = true stats_command_string = true stats_reset_on_server_start = false Any tip? Thanks in advance, Hugo Ferreira -- GPG Fingerprint: B0D7 1249 447D F5BB 22C5 5B9B 078C 2615 504B 7B85 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [PERFORM] Help trying to tune query that executes 40x slower than in SqlServer

plication_out_all), followed by a filter with columns from the second index (trans_id, ent_id, pk1, pk2, pk3, pk4, pk5, pk6, pk7), though the 'age' column is not used... Any guess why?? Thanks in advance, Hugo Ferreira > It is possible but complicated to determine that reordering outer joi

Re: [PERFORM] Help trying to tune query that executes 40x slower than in SqlServer

chment. Once again thanks for your help, Hugo Ferreira > Can you *format* this query please, and re-submit it? Proper query format > looks like: > > SELECT a.1, b.2 > FROM a JOIN b ON a.1 = b.3 > JOIN c ON b.4 = c.1 > WHERE a.5 < 6 > AND c.7 = '

[PERFORM] Help trying to tune query that executes 40x slower than in SqlServer

) (actual time=0.000..0.000 rows=0 loops=14862)" " -> Seq Scan on mrs_replication_out "out" (cost=0.00..128.92 rows=1 width=42) (actual time=0.000..0.000 rows=0 loops=1)" "Filter: ((trans_id = 514::numeric) A