From: | "Matthew Terenzio" <mterenzio(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: tsearch 2 query |
Date: | 2008-10-02 15:31:23 |
Message-ID: | 852b23f40810020831p1e1a3fe8o61ee2e4afef49bb8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-10-02 15:37:37 | Re: Transactions within a function body |
Previous Message | Gurjeet Singh | 2008-10-02 15:30:52 | Re: Transactions within a function body |