Join query on 1M row table slow

Поиск
Список
Период
Сортировка
От CSN
Тема Join query on 1M row table slow
Дата
Msg-id 20040210195110.75252.qmail@web40601.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Join query on 1M row table slow  (lists@natserv.com)
Re: Join query on 1M row table slow  (Richard Huxton <dev@archonet.com>)
Re: Join query on 1M row table slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
I have a pretty simple select query that joins a table
(p) with 125K rows with another table (pc) with almost
one million rows:

select p.*
from product_categories pc
inner join products p
on pc.product_id = p.id
where pc.category_id = $category_id
order by p.title
limit 25
offset $offset

The query usually takes about five seconds to execute
(all other PG queries perform fast enough). I have
indexes on everything needed, and EXPLAIN shows
they're being used. Is there anything else I can do to
improve performance - such as tweaking some settings
in the config?

Redhat 9, PG 7.4.1.

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

В списке pgsql-general по дате отправления:

Предыдущее
От: Iker Arizmendi
Дата:
Сообщение: PQunescapeBytea
Следующее
От: "Peter Darley"
Дата:
Сообщение: Re: Transfer database tables to a schema