From: | Eugene Fokin <elf(at)solvo(dot)ru> |
---|---|
To: | Victor Yegorov <viktors(dot)jegorovs(at)nordlb(dot)lv> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: 7.3.2 vs 7.1.2 |
Date: | 2003-05-21 07:08:16 |
Message-ID: | 20030521070816.GA4664@solvo.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, May 20, 2003 at 06:58:01PM +0300, Victor Yegorov wrote:
>
> Try changing the join above to:
>
> loads l JOIN rcn_details r ON r.id = l.rcn_id
>
Nothing, I mean - the same result.
>
> Also, give the full description of fields, involved in your
> load_rcn_id_idx and rcn_detail_idx indicies.
>
\d load_rcn_id_idx:
Index "public.load_rcn_id_idx"
Column | Type
--------+---------
rcn_id | integer
btree, for table "public.loads"
\d loads:
...
rcn_id | integer | not null default 0
...
\d rcn_detail_idx:
Index "public.rcn_detail_idx"
Column | Type
--------+---------
id | integer
unique, btree, for table "public.rcn_details"
\d rcn_details:
...
id | integer | default nextval('rcn_details_id'::text)
...
\d rcn_details_id
Sequence "public.rcn_details_id"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean
--
Eugene Fokin
SOLVO Ltd. Company
From | Date | Subject | |
---|---|---|---|
Next Message | Eugene Fokin | 2003-05-21 07:11:25 | Re: 7.3.2 vs 7.1.2 |
Previous Message | Tom Lane | 2003-05-20 17:33:40 | Re: 7.3.2 vs 7.1.2 |