Postgres Pro
Downloads
Home   >   mailing lists

Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?
Date
Msg-id 4CBD6FFF0200002500036B27@gw.wicourts.gov
Whole thread Raw
In response to Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-performance
Tree view 
Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:

> how is the query cost calculated? What are
> the units? I/O requests? CPU cycles? Monopoly money?

http://www.postgresql.org/docs/current/interactive/runtime-config-query.html#RUNTIME-CONFIG-QUERY-CONSTANTS

-Kevin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: odd postgresql performance (excessive lseek)
Next
From: Jon Nelson
Date:
Subject: Re: odd postgresql performance (excessive lseek)