Roberto,
I would look at ZomboDB: https://www.zombodb.com/ . Which is exactly what
you suggest.
JD
On Wed, Apr 8, 2020 at 10:28 AM Roberto Della Pasqua <
roberto.dellapas...@live.com> wrote:
> Please sorry because I’m newbie of PGSQL
>
>
>
> I need the best performing and overall quality full-t
Many thanks! That clarifies things well.
Jimmy
On Wed, Apr 8, 2020, at 11:49 AM, Adrian Klaver wrote:
> On 4/8/20 7:35 AM, Jimmy Thrasher wrote:
> > Am I missing something about how sorting works?
>
> I believe you are looking for 'C' collation:
>
> test=# select unnest(array[('> N' collate "C
Please sorry because I'm newbie of PGSQL
I need the best performing and overall quality full-text search, can be
possible to have the data stored in pgsql and the index to elasticsearch? Can
be in sync between?
Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
ww
Greetings,
* BGoebel (b.goe...@prisma-computer.de) wrote:
> initdb --data-checksums "... help to detect corruption by the I/O system"
> There is an (negligible?) impact on performance, ok.
>
> Is there another reason NOT to use this feature ?
Not in my view.
> Has anyone had good or bad exper
Greetings,
* Vano Beridze (vanua...@gmail.com) wrote:
> What are the plans to support multi-master natively?
> What solution would you recommend at this point? preferably free.
You probably want to look at logical replication, which allows you to
replicate data from one PG server to another (with
Sounds like you should design a function to call custom views based on what is
needed.Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone
Original message From: Mark Bannister
Date: 4/8/20 11:39 (GMT-05:00) To: Adrian
Klaver , pgsql-general@lists.postgresql.org Subjec
On 4/8/20 7:35 AM, Jimmy Thrasher wrote:
I'm seeing some unexpected behavior when sorting some strings, and it indicates
I don't fully understand how postgresql string sorting works.
As I understand it, postgresql sorts strings roughly like strcmp does:
character by character based on encoding
"Jimmy Thrasher" writes:
> As I understand it, postgresql sorts strings roughly like strcmp does:
> character by character based on encoding value.
Only if you're using C locale. Other locales such as en_US have
completely different rules, which most hackers tend to find pretty
unintelligible a
On 4/8/20 8:39 AM, Mark Bannister wrote:
On 4/8/2020 10:28 AM, Adrian Klaver wrote:
On 4/8/20 6:39 AM, Mark Bannister wrote:
I am converting an application to postgresql. On feature I have is
functions that return custom displays of a table row. For instance
the company display function mig
On 4/8/2020 10:28 AM, Adrian Klaver wrote:
> On 4/8/20 6:39 AM, Mark Bannister wrote:
>> I am converting an application to postgresql. On feature I have is
>> functions that return custom displays of a table row. For instance
>> the company display function might display just the company name, o
I'm seeing some unexpected behavior when sorting some strings, and it indicates
I don't fully understand how postgresql string sorting works.
As I understand it, postgresql sorts strings roughly like strcmp does:
character by character based on encoding value.
In particular, I'm seeing the foll
On 4/8/20 6:39 AM, Mark Bannister wrote:
I am converting an application to postgresql. On feature I have is
functions that return custom displays of a table row. For instance the
company display function might display just the company name, or company
name + other information. It may also ca
st 8. 4. 2020 v 15:34 odesílatel Andrus napsal:
> Hi
>
> >this query is little bit strange - it has pretty big cost, and because
> returns nothing, then it's pretty fast against cost.
> >there is 18 subqueries, but jit_above_cost is ralated just to one query.
> This is probably worst case for JIT
I am converting an application to postgresql. On feature I have is
functions that return custom displays of a table row. For instance the
company display function might display just the company name, or company
name + other information. It may also call other displays, for
instance, address or p
Hi
>this query is little bit strange - it has pretty big cost, and because returns
>nothing, then it's pretty fast against cost.
>there is 18 subqueries, but jit_above_cost is ralated just to one query. This
>is probably worst case for JIT.
>This query is pretty slow and expensive (and then t
On 2020-03-30 17:30:32 -0400, Tom Lane wrote:
> Don Seiler writes:
> > Actually, would I need to re-index on text columns that we know contain
> > UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII
> > characters.
>
> I think you're all right with respect to those, since the
Hi
út 7. 4. 2020 v 23:56 odesílatel Andrus napsal:
> Hi!
>
> >It is really strange why it is too slow. Can you prepare test case? Looks
> like bug (maybe not Postgres's bug)
>
> Testcase is below.
> With jit on it takes 3.3 sec and with jit off 1.5 sec.
>
> Andrus.
>
> create temp table toode
On Tue, 2020-04-07 at 15:51 -0400, David Gauthier wrote:
> But for my edification, is it roughly true that 2 connections working with
> the DB 100%
> of the time is equivalent to 20 connections @ 10% = 200 connections @ 1 % (if
> you know what I mean) ?
Roughly, yes.
There is a certain overhead,
On 2020-04-07 18:41, Don Seiler wrote:
Follow-up question, the locale setting on the host would still be set to
en_US (as would the postgres and template0 databases). Should I look to
change that locale on the system to en_US.UTF-8, or even just for the
postgres user that the DB cluster runs as
19 matches
Mail list logo
