Postgres Pro
Downloads
Home   >   mailing lists

Re: Join over two tables of 50K records takes 2 hours - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Join over two tables of 50K records takes 2 hours
Date
Msg-id CAOR=d=2zPgFH=sGNrqEe7OQp5PLAF2+SG5W3AS5ZRcom7S6p7w@mail.gmail.com
Whole thread Raw
In response to Join over two tables of 50K records takes 2 hours  (Svetlin Manavski <svetlin.manavski@gmail.com>)
List pgsql-performance
Tree view 
It seems like your row estimate are way off, with the planner
expecting 1 and getting 3000 or so.  Have you tried cranking up
default stats target to say 1000, running analyze and seeing what
happens?

If that doesn't do it, try temporarily turning off nested loops:

set enable_nestloop = off;
explain analyze yourqueryhere;

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Join over two tables of 50K records takes 2 hours
Next
From: CSS
Date:
Subject: SSD options, small database, ZFS