Re: [HACKERS] Proposal: global index

2017-08-18 Thread Erikjan Rijkers
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

Re: [HACKERS] Let us fix the documentation

2013-12-11 Thread Erikjan Rijkers
On Wed, December 11, 2013 22:51, AK wrote: The following url seems to be slightly incorrect: PREPARE usrrptplan (int) AS SELECT * FROM users u, logs l WHERE u.usrid=$1 AND u.usrid=l.usrid AND = $2; EXECUTE

[HACKERS] invalid magic number in log segment

2013-12-10 Thread Erikjan Rijkers
, 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, Erikjan Rijkers -- Sent via pgsql-hackers

Re: [HACKERS] 9.3 Beta1 status report

2013-04-23 Thread Erikjan Rijkers
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 ( To make changes to your subscription:

Re: [HACKERS] WIP: index support for regexp search

2013-04-03 Thread Erikjan Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2013-04-02 Thread Erikjan Rijkers
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

[HACKERS] matview join view error

2013-03-10 Thread Erikjan Rijkers
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