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
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
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
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
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
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
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
