In
http://momjian.us/expire/fulltext/HTML/textsearch-intro.html#TEXTSEARCH-DOCUMENT
it says:
"A document is any text file that can be opened, read, and modified."
Is this an openfts docs relic? tsearch2 is not meant to be be reading
out-of-database *files*, or is it?
If it is actually the case
On 2017-08-18 11:12, Ildar Musin wrote:
Hi hackers,
While we've been developing pg_pathman extension one of the most
frequent questions we got from our users was about global index
support. We cannot provide it within an extension. And I couldn't find
any recent discussion about someone implemen
With 9.3devel, I can't seem to join a matview to a view; surely that should be
allowed?
Here is an example:
-8<--
#!/bin/sh
echo "
drop table if exists t1 cascade;
drop table if exists t2 cascade;
drop materialized view if exists mv ;
create table t1 as select chr(i) as c1, i from g
On Mon, April 1, 2013 23:15, Alexander Korotkov wrote:
[trgm-regexp-0.14.patch.gz]
Hi Alexander,
Something went wrong in this version of the patch: many (most) queries that
were earlier
spectacularly fast have become slow, often slower than a seqscan or only
marginally faster. See
the attached
On Tue, April 2, 2013 23:54, Alexander Korotkov wrote:
> [trgm-regexp-0.15.patch.gz]
Yes, it does look good now; Attached a list of measurements. Most of the
searches that I put in
that test-program are now speeded up very much.
There still are a few regressions, for example:
HEAD azj
I just spotted some more small stuff:
s/IF NOT EXIST /IF NOT EXISTS /g # 2 x
It actually had me doubting, but yes that -S should be there...
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgr
e any way that I can recognize,
beforehand, at the code base level, such an
impending 'invalid magic number' state?
Can de db be recovered from easily? (although this dev database is expendable,
it takes many hours to rebuild; I'd like to
avoid that if possible).
thanks,
Erikja
On Wed, December 11, 2013 22:51, AK wrote:
> The following url seems to be slightly incorrect:
>
> http://www.postgresql.org/docs/9.3/static/sql-prepare.html
>
> PREPARE usrrptplan (int) AS
> SELECT * FROM users u, logs l WHERE u.usrid=$1 AND u.usrid=l.usrid
> AND l.date = $2;
> EXECUTE usr
