Re: 4s query want to run faster
От
Adonias Malosso
Тема
Re: 4s query want to run faster
Дата
Msg-id
8a5d3c890802211311m5fab66d6q865fda1737e47802@mail.gmail.com
Ответ на
Re: 4s query want to run faster (Claus Guttesen)
Список
Дерево обсуждения
4s query want to run faster "Adonias Malosso" <malosso@gmail.com>
Re: 4s query want to run faster "Claus Guttesen" <kometen@gmail.com>
Re: 4s query want to run faster "Adonias Malosso" <malosso@gmail.com>
Re: 4s query want to run faster "Claus Guttesen" <kometen@gmail.com>
Re: 4s query want to run faster "Adonias Malosso" <malosso@gmail.com>
Re: 4s query want to run faster Mark Kirkwood <markir@paradise.net.nz>
Re: 4s query want to run faster "Scott Marlowe" <scott.marlowe@gmail.com>
Re: 4s query want to run faster Mark Kirkwood <markir@paradise.net.nz>
Re: 4s query want to run faster Dave Cramer <pg@fastcrypt.com>
Re: 4s query want to run faster "Scott Marlowe" <scott.marlowe@gmail.com>
Re: 4s query want to run faster "Adonias Malosso" <malosso@gmail.com>
Re: 4s query want to run faster "Scott Marlowe" <scott.marlowe@gmail.com>
On Thu, Feb 21, 2008 at 6:10 PM, Claus Guttesen <kometen@gmail.com> wrote:
Postgresql v. 8.2.1
> The following query takes about 4s to run in a 16GB ram server. Any ideasMaby random_page_cost is set too high? What version are you using?
> why it doesn´t use index for the primary keys in the join conditions?
Postgresql v. 8.2.1
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.
Shakespeare
В списке pgsql-performance по дате отправления
