On Thu, Sep 09, 2010 at 11:16:36AM -0400, Tom Lane wrote:
> Henk van Lingen writes:
> > On Thu, Sep 09, 2010 at 10:50:52AM -0400, Tom Lane wrote:
> >>>> Well, there's your problem: the planner is off by a factor of about 500
> >>>> on its estima
On Thu, Sep 09, 2010 at 10:50:52AM -0400, Tom Lane wrote:
> Henk van Lingen writes:
> > -> Bitmap Heap Scan on systemevents (cost=61221.23..668806.93
rows=239805 width=158) (actual time=9.131..1786.406 rows=464 loops=1)
> >Recheck Cond: (to
ies like those you could try to
> use a combined index like this:
>
> CREATE INDEX msgs_idx (to_tsvector('english'::regconfig, message), id)
> ON systemevents USING (gin);
I will look into this.
Thanks,
--
Henk van Lingen, ICT-SC Netwerk & Telefonie,
r: (to_tsvector('english'::regconfig, message) @@ to_tsquery('error'::te
xt))
(3 rows)
So I'm afraid that not being able to force a plan is a showstopper for
using postgresql with full text search for this project.
Regards,
--
Henk van Linge
No ideas on this one?
Regards,
On Tue, Aug 31, 2010 at 04:50:09PM +0200, Henk van Lingen wrote:
>
> Hi,
>
> I've the problem my database is not using the 'right' queryplan in all
> cases. Is there a way I can force that and/or how should I
stemevents | r | 2.06915e+06 | 694826
(6 rows)
syslog=# SELECT relname, relkind, reltuples, relpages
FROM pg_class
WHERE relname LIKE 'msg%';
relname | relkind | reltuples | relpages
--+-+-+--
msgs_idx | i | 2.06915e+06 | 128069
(1 row)
How to use
ter: (to_tsvector('english'::regconfig, message) @@
to_tsquery('131.211.1.124'::text))
(3 rows)
doing something like
select datetime,facility,level,host,program,pid,message from fw_msgs where
message in (select message from fw_msgs where to_tsvector('englis
is done, i suppose.
However, I'm using the new syslog-ng 3 feature which does the
insert directly. So I have to change the syslogd for that.
I understand the ts_search parser is not configurable?
Thanks,
--
Henk van Lingen,
6.192.46(0) -> some-fwsm/123.456.221.121(0)
Regards,
--
Henk van Lingen, (o- -+
Netwerk & Telefonie, ICT Service Center /\|
Universiteit Utrecht, Jenalaan 18a, kamer 1.40v_/_
http://h
.
Which of these is right? I hope the last also holds for 'trust' lines?
(and yes, i know you don't want to use this :-))
Regards,
--
Henk van Lingen, Systems & Network Administrator (o- -+
Dept. of Computer Science, Utrecht University./\
ls to make them... (jade, sgml,...)
Regards,
+---+
| Henk van Lingen, Systems Administrator, <[EMAIL PROTECTED]> |
| Dept. of Computer Science, Utrecht University. phone: +31-30-2535278 |
+---
n my Redhat 6.1 system.
The same configure options do work on the same Solaris system with
postgresql version 6.5.3
Where to look now?
Regards,
PS: no ideas on my yesterday mentioned moddatetime prob?
+-------+
| Henk van
Hi *,
Will version 7 have the possibility of defining a view on a union?
And if not, how can I simulate one? Only by creating some procedure
which uses tmp tables or something?
Cheers,
+---+
| Henk van Lingen, Systems
places where PL/pgSQL is explained?
By the way: I'm using 6.5.2 on RedHat 6.1
Regards,
+---+
| Henk van Lingen, Systems Administrator, <[EMAIL PROTECTED]> |
| Dept. of Computer Science, Utrecht University. phone: +31-30-2535278 |
+- http://www.cs.uu.nl/people/henkvl/ --+
14 matches
Mail list logo