On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh
wrote:
> This item isn't valid, is it?
>
>
>- There isn't phrase search with GIN index. This problem relates with
>previous problem. It is need position information to perform phrase search.
>
> RUM being an extention, and having inde
This item isn't valid, is it?
* There isn't phrase search with GIN index. This problem relates with
previous problem. It is need position information to perform phrase search.
RUM being an extention, and having index-access-methods as extentions is new
in 9.6, where phrase-search was introdu
Hi.
The following TODO-items are on RUM's TODO-list:
* Allow multiple additional information (lexemes positions + timestamp).
* Add support for arrays.
Will any of these items support storing BIGINT as part of a tsvector+timestamp?
so one an have an index like this:
create index rum_idx
Thank you so much for your references.
How the planning factors of PGStrom differs from planning factos of
PostgreSQL?
--
View this message in context:
http://postgresql.nabble.com/How-the-Planner-in-PGStrom-differs-from-PostgreSQL-tp5929724p5930356.html
Sent from the PostgreSQL - general mail
On 11/14/2016 9:25 PM, Mark Anns wrote:
I am just curious about this planning factors in GPU.
There can be more than one appropriate paths in query plan tree. How the
decision for particular path has been made considering those planning
factors?
the postgresql planner considers a number of al
Hi,
The issue is not with server , it is running fine .
Issue is not with port either , for local machine, I guess firewall won't
affect.
On Tue, Nov 8, 2016 at 8:14 PM, Adrian Klaver
wrote:
> On 11/07/2016 07:27 PM, kaustubh kelkar wrote:
>
>>
>> Hi ,
>>
>> I am a PostgreSQL user who wan
Thank you so much for your kind reply.
I am just curious about this planning factors in GPU.
There can be more than one appropriate paths in query plan tree. How the
decision for particular path has been made considering those planning
factors?
--
View this message in context:
http://p
Hi,
Trying to create multiple database instances of PostgreSQL 9.6
In this case , trying to create 2nd instance with port 5434/5435.
*1st attempt:*
*Create new database cluster : *
C:\Program Files\PostgreSQL\9.6\installer\server>initcluster.vbs postgres
postgr
es 12345 "C:\Program File
Sorry, I got the question a week before from the sender but couldn't respond
timely.
> I am reading through Postgres and PGStrom. Regarding the planning factors,
> I need some clarifications. Can u help me with that?
>
> Planner in Postgres checks for different scan and join methods, and then
>
On 11/14/2016 10:21 AM, Poul Kristensen wrote:
Can't the gcc compiler be used for the subject
oops, left out the documentation link re ECPG,
https://www.postgresql.org/docs/current/static/ecpg.html
--
john r pierce, recycling bits in santa cruz
On 11/14/2016 10:21 AM, Poul Kristensen wrote:
Can't the gcc compiler be used for the subject
I have ordered the book "Postgresql for develophers" and hope to see
some examples there
covering C(Gnu) with embedded SQL.
are you talking about ECPG ?
--
john r pierce, recycling bits in santa cru
Can't the gcc compiler be used for the subject
I have ordered the book "Postgresql for develophers" and hope to see
some examples there
covering C(Gnu) with embedded SQL.
Thanks
Poul
On 11/14/2016 10:21 AM, Poul Kristensen wrote:
Can't the gcc compiler be used for the subject
Without sample code and an error message there isn't much we can do here.
jD
I have ordered the book "Postgresql for develophers" and hope to see
some examples there
covering C(Gnu) with embedded S
On Nov 14, 2016 12:53, "valeriof" wrote:
>
> Hi,
> I'm handling a TimestampTz value inside a plugin to stream WAL changes to
a
> .NET client application. What I'm trying to do is to return all possible
> column changes as binary (don't like to have Postgres handle the
conversion
> to string as I m
Jerome Wagner writes:
> seeing you answer I have a question for which I found no answer a few weeks
> ago : is there a way to know at runtime which internal representation
> timestamps have ?
You can inspect the integer_datetimes setting, via SHOW or
current_setting(). In a libpq client it's als
Jerome Wagner wrote:
> seeing you answer I have a question for which I found no answer a few weeks
> ago : is there a way to
> know at runtime which internal representation timestamps have ?
> I am trying to deal with the COPY binary protocol with only SQL access to the
> remote server and would
Hello,
seeing you answer I have a question for which I found no answer a few weeks
ago : is there a way to know at runtime which internal representation
timestamps have ?
I am trying to deal with the COPY binary protocol with only SQL access to
the remote server and would like to find a way to know
On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote:
Please reply to list also.
Ccing list.
9.3
it just says syntax error near (
Can you show the actual complete error?
I have a variable QByteArray that stores the fingerprint data, then:
I am using QString Query = "insert into tableName
On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote:
9.3
it just says syntax error near (
I have a variable QByteArray that stores the fingerprint data, then:
I am using QString Query = "insert into tableName(colName) values
(:valName)";
prepare the query;
then query.bindValue;
lastly query.
valeriof wrote:
> I'm handling a TimestampTz value inside a plugin to stream WAL changes to a
> .NET client application. What I'm trying to do is to return all possible
> column changes as binary (don't like to have Postgres handle the conversion
> to string as I may need to have access to the byte
Hi,
I'm handling a TimestampTz value inside a plugin to stream WAL changes to a
.NET client application. What I'm trying to do is to return all possible
column changes as binary (don't like to have Postgres handle the conversion
to string as I may need to have access to the bytes at the client leve
Hi,
On 2016-11-13 23:04:44 +, James Sewell said:
> 1. INSERT ... SELECT doesn't work
> 2. WITH a AS (SELECT ...) INSERT FROM a doesn't work
> 3. SELECT .. INTO doesn't work
> 4. SELECT with no insert does work as expected
>>
>> CREATE TABLE blah AS
On 11/13/2016 11:52 PM, Yogesh Sharma wrote:
you can look those relation numbers up in the pg_catalog to see what they are.
you can see what the processes are in pg_stat_activity.
Currently machine is not available. Please suggest if any other approach to
identify the same.
without acces
23 matches
Mail list logo
