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
)
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
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]>
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 <
)
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
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
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
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
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)
--
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)--
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)--
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
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
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
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:
15 matches
Mail list logo
