Re: Bad plan choice nestloop vs. hashjoin

On Fri, Jan 15, 2010 at 04:58:57PM -0600, Kevin Grittner wrote:
> Kenneth Marshall <ktm@rice.edu> wrote:
>
> > with the default settings
>
> Do you mean you haven't changed any settings in your postgresql.conf
> file from their defaults?
>
> -Kevin
>
Sorry, here are the differences from the default:

max_connections = 100                   # (change requires restart)
shared_buffers = 256MB                  # min 128kB or max_connections*16kB
work_mem = 16MB                         # min 64kB
maintenance_work_mem = 512MB            # min 1MB
synchronous_commit = off                # immediate fsync at commit
wal_buffers = 256kB                     # min 32kB
checkpoint_segments = 30                # in logfile segments, min 1, 16MB each
seq_page_cost = 1.0                     # measured on an arbitrary scale
random_page_cost = 2.0                  # same scale as above
effective_cache_size = 12GB
log_min_duration_statement = 5000

The machine has 16GB of RAM and the DB is currently about 8GB. It
is going to grow much larger as information is acquired.

Cheers,
Ken