Hi
I am seeking some clarification in regard to full text search across
multiple tables and what the best approach is. Documentation talks about
two approaches when it comes to building a document: on-the-fly concat
of columns and a dedicated tsv column approach. Let's say I want to
perform a
Something funny going on with my full text search.. and I have no idea what.
I have a receiver called "Ana", this is her tsv column:
'3865100':4 'acevent...@mailinator.com':3B 'ana':1A 'novak':2A
This queries do not find her:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('a:*'
Thanks, that makes sense. I think I'll go with the cast approach, I
don't really need stemming anywhere.
Tom Lane je 02. 12. 2016 ob 16:33 napisal:
cen writes:
Something funny going on with my full text search.. and I have no idea what.
The way to debug this sort of thing is ge
Hi
I have this FTS query:
SELECT * FROM receivers r WHERE r.tsv @@ unaccent('john:*')::tsquery
ORDER BY ts_rank(r.tsv, unaccent('john:*')::tsquery) DESC;
Is there any way to tell FTS to put records with "John" first and others
after that (Johhny, Johnson etc)?
Basically, I want to have ful
How about PGCon? I've never been but the online videos are always
interesting.
Nathan Stocks je 28. 02. 2017 ob 00:25 napisal:
What worthwhile conferences should a PostgreSQL DBA consider going to?
There have been some good sessions at OSCON in the past, but I was
wondering about more DBA-
ripts, there is nothing external that would cause this so my guess is
that this is internal Postgres cron job tryin to do "something", I just
don't know what exactly.
We have WAL replication set up, these logs appear on master. Perhaps we
have something off in our conf?
Best r
Hmm indeed that seems to be the case. Thanks for the tip!
On 05/19/2017 04:10 PM, John R Pierce wrote:
On 5/19/2017 1:25 AM, cen wrote:
< 2017-05-15 17:00:41.861 CEST >LOG: parameter "archive_command"
changed to ""/opt/omni/lbin/pgsqlbar.exe" -stage %p -backup
Hi
Given a basebackup base.tar.gz and an archive of WAL files, is there any
way to find out which .backup WAL file is associated with the basebackup
from command line?
My use case is for a retention policy bash script which:
-deletes all basebackups older than X days
-runs pg_archivecleanup
ewest differences over
to the recovery. So far I was unable to find a supersecret git repo with
bash scripts accomplishing this tasks which is surprising.
On 07/13/2017 11:26 AM, Michael Paquier wrote:
On Thu, Jul 13, 2017 at 10:30 AM, cen wrote:
Given a basebackup base.tar.gz and an archive of
