Postgres Pro
Downloads
Home   >   mailing lists

Re: tsearch 2 query - Mailing list pgsql-general

From Matthew Terenzio
Subject Re: tsearch 2 query
Date
Msg-id 852b23f40810020831p1e1a3fe8o61ee2e4afef49bb8@mail.gmail.com
Whole thread Raw
In response to Re: tsearch 2 query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: tsearch 2 query  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: tsearch 2 query  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view
Thanks Tom, Sorry if that last post went over multiple times. I was getting a mailing failure (or so I thought)

here is EXPLAIN ANALYZE . I really need to work on my skills at analyzing these:

Limit  (cost=105505.78..105505.83 rows=20 width=655) (actual time=74806.973..74807.037 rows=20 loops=1)
  ->  Sort  (cost=105505.78..105555.44 rows=19861 width=655) (actual time=74806.968..74806.989 rows=20 loops=1)
        Sort Key: stories."timestamp"
        ->  Nested Loop  (cost=0.00..90497.94 rows=19861 width=655) (actual time=720.251..74798.672 rows=680 loops=1)
              ->  Function Scan on q  (cost=0.00..12.50 rows=1000 width=32) (actual time=0.013..0.017 rows=1 loops=1)
              ->  Index Scan using description_index on stories  (cost=0.00..90.14 rows=20 width=623) (actual time=700.633..63243.713 rows=680 loops=1)
                    Index Cond: (stories.vectors @@ "outer".q)
Total runtime: 74847.177 ms

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: Transactions within a function body
Next
From: Alvaro Herrera
Date:
Subject: Re: Transactions within a function body