Re: [HACKERS] Execution time.
От
The Hermit Hacker
Тема
Re: [HACKERS] Execution time.
Дата
Msg-id
Pine.NEB.3.95.980204113746.24451W-100000@hub.org
Ответ на
Re: [HACKERS] Execution time. (Shiby Thomas)
Список
Дерево обсуждения
v6.3beta testing starting The Hermit Hacker <scrappy@hub.org>
Compilation error on sparc-solaris Shiby Thomas <sthomas@cise.ufl.edu>
compilation on sparc_solaris Shiby Thomas <sthomas@cise.ufl.edu>
Re: compilation on sparc_solaris The Hermit Hacker <scrappy@hub.org>
Re: compilation on sparc_solaris Shiby Thomas <sthomas@cise.ufl.edu>
Re: compilation on sparc_solaris The Hermit Hacker <scrappy@hub.org>
Execution time. Shiby Thomas <sthomas@cise.ufl.edu>
On Wed, 4 Feb 1998, Shiby Thomas wrote: > > => > I invoked postmaster as: > => > postmaster -B 30000 -o "-s -F -S 16384" > => ^^^^^ > => 240M of shared memory ?! > => > Is the size of the hash bucket dependent on the number of buffers available ? > If so, with -B 30000, it might create huge hash buckets and hence the > hash join could degenerate to a nested loops join. Is that possible -- just > checking. What could be good values for -B and -S. The largest table I am > joining is about 60M My production server runs with a -B 256, and a -S 10240
В списке pgsql-hackers по дате отправления
