Re: PG planning randomly ?

2008/2/26, Laurent Raufaste <analogue@glop.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/>