From: | "Laurent Raufaste" <analogue(at)glop(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PG planning randomly ? |
Date: | 2008-02-26 15:35:03 |
Message-ID: | 669dc9710802260735y2fb72ec9l2aa70c12c6636ea0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
2008/2/26, Laurent Raufaste <analogue(at)glop(dot)org>:
> Hi,
>
> I'm having some issues with this simple query:
>
> SELECT
> _comment.*,
> _article.title AS article_title,
> _article.reference AS article_reference
> FROM
> _comment
> INNER JOIN _article
> ON _article.id = _comment.parent_id
> WHERE
> _comment.path <@ '0.1.3557034'
> ORDER BY
> _comment.date_publishing DESC
> OFFSET 0
> LIMIT 5
> ;
I forgot the table definition, here it is ;)
Table "ob2._comment"
Column | Type |
Modifiers
-------------------+-----------------------------+--------------------------------------------------------------
id | bigint | not null default
nextval('element_id_sequence'::regclass)
parent_id | bigint |
path | ltree |
data | text |
date_creation | timestamp without time zone | not null default now()
date_publishing | timestamp without time zone | not null default now()
date_modification | timestamp without time zone | not null default now()
counters | hstore |
reference | integer | not null default
nextval('_comment_reference_seq'::regclass)
text | text |
Indexes:
"_comment_pkey" PRIMARY KEY, btree (id), tablespace "indexspace"
"gist_idx_comment_path" gist (path), tablespace "indexspace"
"idx_comment_date_creation" btree (date_creation), tablespace "indexspace"
"idx_comment_date_publishing" btree (date_publishing), tablespace
"indexspace"
"idx_comment_parent_id" btree (parent_id), tablespace "indexspace"
"idx_comment_reference" btree (reference), tablespace "indexspace"
Inherits: _element
Thanks for looking into ou problem !
--
Laurent Raufaste
<http://www.glop.org/>
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Stevenson | 2008-02-26 16:26:30 | Re: LISTEN / NOTIFY performance in 8.3 |
Previous Message | Laurent Raufaste | 2008-02-26 15:19:03 | PG planning randomly ? |