Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: query optimizer
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "jungmin shin" <jungmin(dot)shin(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: query optimizer
- Date: Tue, 17 Apr 2007 00:48:58 -0400
- Message-id: <14986(dot)1176785338(at)sss(dot)pgh(dot)pa(dot)us>
"jungmin shin" <jungmin(dot)shin(at)gmail(dot)com> writes: > As I see the documentation of postgres, postgres use genetic algorithm for > query optimization rather than system R optimizer. right? Only for queries with more than geqo_threshold relations. The join search algorithm for smaller queries is a System-R-like dynamic programming method. regards, tom lane
- References:
- query optimizer
- From: jungmin shin
- query optimizer
- Prev by Date: query optimizer
- Next by Date: Re: string fields helps
- Previous by thread: query optimizer
- Next by thread: seeking PITR archive_command advice
- Indexes: