Thank you David, I will do something similar.
2018-05-05 3:12 GMT+02:00 David G. Johnston :
> On Friday, May 4, 2018, Havasvölgyi Ottó
> wrote:
>
>>
>> Now I am thinking about splitting the input text myself to terms, then
>> searching and ranking the documents for each term.
>>
>
> Maybe do: r
On Friday, May 4, 2018, Havasvölgyi Ottó wrote:
>
> Now I am thinking about splitting the input text myself to terms, then
> searching and ranking the documents for each term.
>
Maybe do: replace(input_text, ' ', ' | ')
David J.
Based on the docs, plainto_tsquery() creates tsquery with the & operator (
https://www.postgresql.org/docs/10/static/functions-textsearch.html), so
the @@ operator will not find partial matches. And this way I cannot
calculate ts_rank for those partial matches.
Now I am thinking about splitting the
On Friday, May 4, 2018, Havasvölgyi Ottó wrote:
> so that it matches (with less rank) even if one of its words match ?
>
That seems to be what "ts_rank" provides.
David J.
Hi,
I would like to use PostgreSQL's FTS functionality.
The user would enter a search text, one or more words.
There is a suitable plainto_tsquery() function, but it's to strict. It
only matches if all words match. What is the best practice to make this
kind of search more "forgiving", so that it
Anudeep Gudipelli writes:
> I would like to know the known bugs for v9.5 and also v9.6, is there any
> place where I can check?
See release notes at
https://www.postgresql.org/docs/current/static/release.html
regards, tom lane
Hi Team,
I am writing this email regarding Postgres 9.5 version, I found that you are
one of the professional services in North America.
I am JIRA and Confluence administrator in my organization and we are planning
to upgrade these both instance, while investigation I found that our current
Po
hi,all
I got this when setup two replication server:
致命错误: 在主用服务器和备用服务器之间，数据库系统标识符是不一样的。
详细信息: 主用服务器的标识符是6551342231479624101，备用服务器的标识符是6551367700460643417。
---fatal erro: in main and backup server ,the database 's system id is not
same...
what's mean of this ,how to deal with ?
Tha
nikhil raj schrieb am 04.05.2018 um 18:45:
But here is the issue is here we have 200+ databases and 5 servers so
cannot manually runs this command all ways is there any 3rd party
tool for that which would give me the hits on DB and tables in it so
that it would be so help full for me.
now curre
On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver
wrote:
>On 05/03/2018 09:47 AM, George Neuner wrote:
>>
>> ..., I would not discount the possibility that Microsoft really
>> has patented some variation of CSV. They absolutely did *try* to
>> copyright the use of + and - symbols for specifying
On 05/04/2018 09:45 AM, nikhil raj wrote:
Hi Adrian Klaver,
Thanks for the fast response .
But here is the issue is here we have 200+ databases and 5 servers so
cannot manually runs this command all ways is there any 3rd party tool
for that which would give me the hits on DB and tables in it
On 05/04/2018 09:52 AM, Ian Harding wrote:
I know there are a lot of moving parts to this issue but I think I've
eliminated most of them and the problem comes down to the postgresql
server generating a statement_timeout error after 10 seconds when the
connection statement_timeout is actually se
Hi,
On 2018-05-04 09:52:35 -0700, Ian Harding wrote:
> I know there are a lot of moving parts to this issue but I think I've
> eliminated most of them and the problem comes down to the postgresql server
> generating a statement_timeout error after 10 seconds when the connection
> statement_timeout
I know there are a lot of moving parts to this issue but I think I've
eliminated most of them and the problem comes down to the postgresql server
generating a statement_timeout error after 10 seconds when the connection
statement_timeout is actually set to 15 minutes.
My web server gets a database
Hi Adrian Klaver,
Thanks for the fast response .
But here is the issue is here we have 200+ databases and 5 servers so
cannot manually runs this command all ways is there any 3rd party tool for
that which would give me the hits on DB and tables in it so that it would
be so help full for me.
now
On Thu, May 03, 2018 at 01:24:59PM -0500, Justin Pryzby wrote:
> Yes, I was surprised about the difference between ANALYZE relkind_p
> and relkind_r.
>
> But I see that's a documented behavior I'd missed until now:
>
> https://www.postgresql.org/docs/current/static/sql-analyze.html
> |If the spec
Markus writes:
> I'm running Postgresql 9.6.7 on Debian stretch -- and I'm trying to
> understand a query plan, with any hint where to gain further insight
> welcome.
Well, you say
> select count(*) from gaia.dr2light where parallax>50;
> gives 5400 rows in no time.
but the planner thinks the
On 05/04/2018 04:44 AM, nikhil raj wrote:
Hi,
Any one can please help me out
How to monitor the Hits on database and how many hits on each user
tables Through query.
Is there any other tools for that so it can full fill my requirement for
it .
https://www.postgresql.org/docs/10/static/monit
On 04/05/18 12:07, Peter Eisentraut wrote:
On 5/4/18 06:41, Adrian Heath wrote:
The system is used 24/7. Can we run pg_basebackup while the master is
still receiving updates without worrying about physical file corruptions
in the generated archive file?
Yes, as long as you follow the instructio
Hi,
Any one can please help me out
How to monitor the Hits on database and how many hits on each user tables
Through query.
Is there any other tools for that so it can full fill my requirement for it
.
Thanks,
On 5/4/18 06:41, Adrian Heath wrote:
> The system is used 24/7. Can we run pg_basebackup while the master is
> still receiving updates without worrying about physical file corruptions
> in the generated archive file?
Yes, as long as you follow the instructions about saving the WAL
generated duri
We have master/standby servers running postgresql 9.6.5 on Debian 8.0
(Wheezy) 64 bit and we want to add a 3rd machine, streaming from the
master but running off-site.
The system is used 24/7. Can we run pg_basebackup while the master is
still receiving updates without worrying about physical
Hi,
I'm running Postgresql 9.6.7 on Debian stretch -- and I'm trying to
understand a query plan, with any hint where to gain further insight
welcome.
Situation: Two tables, both with a bigint source_id as primary key:
gaia.dr2light -- roughly 1.6 billion rows, about 30 columns, all of them
reals
23 matches
Mail list logo
