Re: Hash Anti Join performance degradation

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "panam" <panam(at)gmx(dot)net>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hash Anti Join performance degradation
Date: 2011-05-25 17:40:56
Message-ID: 4DDCF8D8020000250003DC5E@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

panam <panam(at)gmx(dot)net> wrote:

> Is there a way to determine the values actually used?

The pg_settings view. Try the query shown here:

http://wiki.postgresql.org/wiki/Server_Configuration

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2011-05-25 17:43:09 Re: Proposal: Another attempt at vacuum improvements
Previous Message Alvaro Herrera 2011-05-25 17:37:07 Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Hunsaker 2011-05-25 18:35:08 Re: Speeding up loops in pl/pgsql function
Previous Message John Rouillard 2011-05-25 17:12:39 Re: "error with invalid page header" while vacuuming pgbench data