to_tsvector
-
'sever':1,2
(1 row)
indie=> select to_tsvector('"severance" several');
to_tsvector
-
'sever':1,2
(1 row)
using the perl library Lingua::Stem::Snowball it yields the same results (as
expected since they both use snowball).
am
that would be more intuitive, but given the query
structure of select with no where the results can be surprising.)
thanks
--
Jeff Trout
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
7;ll have to artifically build up some db traffic on an 8.3 instance
to see if the patch Tom mentioned helps.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 4:
poded). On a 2.4ghz opteron
it took 5-50 seconds per wal segment, and there were a LOT of
segments (replay took hours and hours). I asked a few folks and was
told it is the nature of the beast. Hopefully something in 8.4 can
be done.
--
Jeff Trout <[EMAIL PROTECTE
I don't have more details, this was mostly back around 2001-02
or so.
iirc, didn't some big us govt group move to PG from Informix? I
think Bruce mentioned something once about that..
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.dellsmartexitin.com/
http://www.stuarthamm.ne
rning ("RETURNS SETOF bytea" and some code changes)
and return no rows to indicate no data.
Another possibility is to log an exception with elog & company.
However that will also have the side effect of rolling back the txn
if you are currently in one.
--
Jeff Trout <[EMAIL PROT
you don't pay for it you don't get it.
So we're basically in the same boat as them.. just an add on. we just
offer more variety.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)--
0
0
(8 rows)
taco
--
5
4
3
2
1
0
0
0
(8 rows)
ERROR: column "taco" does not exist
DROP TABLE
thanks
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)--
)
do we even need this file if it is never read?
To help alleviate his problem could he symlink it to /dev/null?
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 3: Have you c
re "shared". Chances are extremely high that all your
apache clients are not issuing queries at the same exact time so your
queries end up getting funnelled into those X connections.
I ran with 32 kids on pg_pool and 350 apache processes. never had a
problem.
--
Jeff Trout <
d to run a site doing hundreds of connects & queries /
second across 4 frontends each of which ran a pg_pool connected to a
db box.
If you fine 32 clients isn't enough, then bump it up. The idea is to
keep as few connections as possible.
--
Jeff Trout <[EMAIL PROTECTED]>
)
Install the new Xcode. that should fix it.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
quot; from machine 1 to machine 2 without much work?
2 methods
1. since it is the same kind of hardware you can shut down PG on
machine1 and tar up $PGDATA move to machine2, untar and fire up PG.
2. pg_dump on machine 1, copy the dump, load up on machine2. (this
will take longer)
--
On May 26, 2005, at 5:04 PM, Hrishikesh Deshmukh wrote:
Is it possible to connect a DB in Postgresql to a DB in MySQL!
I know its a crazy idea!
H
http://pgfoundry.org/projects/dbi-link/
although you'll need a patch to make it work unless the author has
updated it.
--
Jeff Trout &l
worked fine.
Try installing xcode2 and let us know.
(And I compiled and run Tiger on my tiger machine here, with xcode2,
gcc 4)
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP
15 matches
Mail list logo
