Help with performance

Поиск
Список
Период
Сортировка
Искать
От
Uros Gruber
Тема
Help with performance
Дата
Msg-id
85107633618.20020424224912@sir-mag.com
Список
Дерево обсуждения
Help with performance Uros Gruber <uros.gruber@sir-mag.com>
Re: Help with performance Martijn van Oosterhout <kleptog@svana.org>
Hi!

I have 2 tables

\d table1

     Column     |           Type
----------------+--------------------------
 id_entry       | integer
 created        | timestamp with time zone
 title          | character varying(64)
 description    | text

Primary key: table1_pk
Index "table1_pk"
  Column  |  Type   
----------+---------
 id_entry | integer
unique btree (primary key)  

\d table2
   Column    |         Type
-------------+-----------------------
 id_category | character varying(64)
 id_entry    | character varying(64)
Primary key: table2_pk

\d table2_pk
   Column    |         Type          
-------------+-----------------------
 id_category | character varying(64)
 id_entry    | character varying(64)
unique btree (primary key)


Not i have  query like this

select d.title from table1 d, table2 c where c.id_category='09' and d.id_entry=c.id_entry;

This is query plan


-- 
lp,
 Uros                          mailto:uros.gruber@sir-mag.com

В списке pgsql-general по дате отправления
От: Shaun Grannis
Дата:
Сообщение: Performance Issues
От: Uros Gruber
Дата:
Сообщение: Help with performance - No2
FAQ