On Thu, Sep 20, 2018 at 5:11 AM Craig Ringer wrote:
> On Fri, 14 Sep 2018 at 23:11, James Keener wrote:
>
>> And if you believe strongly that a given statement you may have made is
>>> not objectionable...you should be willing to defend it in an adjudication
>>> investigation.
>>
>>
>> So becaus
On Fri, 14 Sep 2018 at 23:11, James Keener wrote:
> And if you believe strongly that a given statement you may have made is
>> not objectionable...you should be willing to defend it in an adjudication
>> investigation.
>
>
> So because someone doesn't like what I say in a venue 100% separate from
On Tue, Sep 18, 2018 at 11:31 PM Thomas Güttler <
guettl...@thomas-guettler.de> wrote:
> Hi,
>
> is it possible to replicate some tables from SAP to PostgreSQL?
> At the moment there are two underlaying database systems.
> Some run DB2 and some run SAP-HANA.
> In my case it would be nice, if it wo
On Wed, Sep 19, 2018 at 6:34 AM Gabriel Furstenheim Milerud <
furstenh...@gmail.com> wrote:
Maybe that is not possible with numbers? To say in a format something like
> "my numbers have comma as decimal separator and no thousands separators" or
> "my numbers are point separated and have comma as t
Hi
After promoting slave to master, I completed a pg_rewind of the slave (old
master) to the new master. But when I try to start the slave I am getting the
following error.
2018-09-20 07:53:51 ACST [20265]: [2-1] db=[unknown],user=replicant
app=[unknown],host=10.69.20.22(51271) FATAL: the dat
Gabriel Furstenheim Milerud writes:
> Sorry,
> So basically what I'm trying to achieve is the following. There is an input
> file from the user and a configuration describing what is being inserted.
> For example, he might have Last activity which is '-MM-DD HH:mi:ss' and
> Join date which
On Wed, Sep 19, 2018 at 7:44 PM Cédric Villemain wrote:
> Le 19/09/2018 à 05:29, Thomas Munro a écrit :
> > On Wed, Sep 19, 2018 at 1:35 PM jimmy wrote:
> >> I use select pg_prewarm('table1','read','main') to load data of table1
> >> into the memory.
> >> when I use select count(1) from table1
On Wed, Sep 19, 2018 at 11:24:29AM +1000, Julian Paul wrote:
> It's overly long and convoluted.
>
> "inclusivity" Is a ideologue buzzword of particular individuals that offer
> very little value apart from excessive policing of speech and behaviour
> assumed to be a problem where none exist.
>
>
On 09/19/2018 04:27 PM, Kevin Grittner wrote:
On Tue, Sep 18, 2018 at 5:28 AM Dave Page wrote:
The PostgreSQL Core team are pleased to announce that following a long
consultation process, the project’s Code of Conduct (CoC) has now been
finalised and published at https://www.postgresql.org
On Tue, Sep 18, 2018 at 5:28 AM Dave Page wrote:
>
> The PostgreSQL Core team are pleased to announce that following a long
> consultation process, the project’s Code of Conduct (CoC) has now been
> finalised and published at https://www.postgresql.org/about/policies/coc/.
>
> Please take time t
Sorry, I emailed using my company account and thus the long sig. In an effort
to avoid further insulting Mr Olarte, I will delete it this time.See,
Self-policing works !
Fred
Greetings,
* Francisco Olarte (fola...@peoplecall.com) wrote:
> I will happily pardon brevity ( although I would not call a ten line
> sig plus a huge bottom quote "breve", and AFAIK it means the same in
> english as in spanish ) and/or typos, but the "I am not responsible"
> feels nearly insultin
On Wed, Sep 19, 2018 at 5:27 PM, Fred Pratt
wrote:
> Keep pg open and free. This smells of PC police. This community can
> police itself
No comment on this, just kept for context.
> Sent from my mobile device. Please pardon my brevity and typos. I am not
> responsible for changes made by
On Wed, 19 Sep 2018 16:30:56 +0200
ERR ORR wrote:
> A CoC will inevitably lead to the project taken over by leftists,
Here we go again.
SteveT
Steve Litt
September 2018 featured book: Quit Joblessness: Start Your Own Business
http://www.troubleshooters.com/startbiz
On 9/19/18 8:39 AM, ncontu1 wrote:
So unexpectedly with the rpms, it installed it on a different place and it is
working from command line
[root@cmd-dev1 pgbouncer]# /bin/pgbouncer /etc/pgbouncer/pgbouncer.ini -u
postgres
2018-09-19 15:38:36.081 46322 LOG File descriptor limit: 1024 (H:4096),
ma
Tatsuo Ishii writes:
> Now that CoC is out,
> https://www.postgresql.org/about/policies/coc/
> I would like to start the translation work. Can somebody suggest me
> how I can proceed?
Sure, translate away. Probably the -www list is the place to discuss
questions like where it would appear on th
Keep pg open and free. This smells of PC police. This community can police
itself
Sent from my mobile device. Please pardon my brevity and typos. I am not
responsible for changes made by this device’s autocorrect feature.
Fred Pratt
AmerisourceBergen
Manager – IT Infrastructure
Micro Tech
So unexpectedly with the rpms, it installed it on a different place and it is
working from command line
[root@cmd-dev1 pgbouncer]# /bin/pgbouncer /etc/pgbouncer/pgbouncer.ini -u
postgres
2018-09-19 15:38:36.081 46322 LOG File descriptor limit: 1024 (H:4096),
max_client_conn: 100, max fds possible
>>> Do we want official translations of this? We allow local communities
>>> do their own manual translations. However CoC is so important, I feel
>>> like we need more for Coc. Good thing with CoC is, it is expected that
>>> it would be stable (at least I hope so) and translation works when
>>> it
The results of explain analyze would shed light on the core problem.
My guess is that your conditions are not very selective - ie. most
records in both tables have bFetch = false - and therefore you are
retrieving most of your data and that is what's taking 7 minutes. No
index is going to fix that
Hi
I have complex query like for ex select distinct
sub_head."vchSubmittersCode" ,rec."vchFileName" ,
rec."vchCusipFundIDSubFundID" , rec."vchFundUnitPrice" ,
sub_head."vchValuationDate" ,rec."vchAdvisorLabel" from "table1" rec join
"table2" sub_head on rec."vchSubmittersCode"=sub_head."vc
Am 19.09.2018 um 16:43 schrieb Durgamahesh Manne:
On Wed, Sep 19, 2018 at 8:02 PM Andreas Kretschmer
mailto:andr...@a-kretschmer.de>> wrote:
Am 19.09.2018 um 15:51 schrieb Durgamahesh Manne:
> I have created BRIN index on few columns of the table without any
> issues. But i
On Wed, Sep 19, 2018 at 8:02 PM Andreas Kretschmer
wrote:
>
>
> Am 19.09.2018 um 15:51 schrieb Durgamahesh Manne:
> > I have created BRIN index on few columns of the table without any
> > issues. But i am unable to create BRIN index on one column of the
> > table as i got error listed below
> >
>
Am 19.09.2018 um 15:51 schrieb Durgamahesh Manne:
I have created BRIN index on few columns of the table without any
issues. But i am unable to create BRIN index on one column of the
table as i got error listed below
[local]:6263 postgres@huawei=# CREATE INDEX brin_idx on huawei using
brin
I was never consulted.
I was only Told that there was a CoC "to be". Not when, not how.
A CoC will inevitably lead to the project taken over by leftists, political
and technical decisions will be made by others.
Most important from my PoV, the projects quality will decrease until its
made unviable.
Am 19.09.2018 um 16:08 schrieb Raghavendra Rao J S V:
Hi All,
Which is the most stable PostgreSQL version yet present for CentOS 7?
the latest supported minor version.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
On Wed, Sep 19, 2018 at 7:41 PM Igor Neyman wrote:
>
>
> *From:* Durgamahesh Manne [mailto:maheshpostgr...@gmail.com]
> *Sent:* Wednesday, September 19, 2018 10:04 AM
> *To:* Igor Neyman
> *Subject:* Re: Regrading brin_index on required column of the table
>
> On Wed, Sep 19, 2018 at 7:19 PM Igo
Hi All,
Which is the most stable PostgreSQL version yet present for CentOS 7?
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
On 9/19/18 6:33 AM, Gabriel Furstenheim Milerud wrote:
Sorry,
So basically what I'm trying to achieve is the following. There is an
input file from the user and a configuration describing what is being
inserted. For example, he might have Last activity which is '-MM-DD
HH:mi:ss' and Join d
On 19/09/18 15:34, Adrian Klaver wrote:
> On 9/19/18 5:40 AM, ncontu wrote:
>> Hi Fabio,
>> It used to work before, even without installing updates.
>
> Exactly, the suspicion is that something in the updates changed the behavior
> of your system.
>
Yes, that's the suspicion. Or at least was..
On 18/09/18 20:27, Dave Page wrote:
The PostgreSQL Core team are pleased to announce that following a long
consultation process, the project’s Code of Conduct (CoC) has now been
finalised and published at https://www.postgresql.org/about/policies/coc/.
Please take time to read and understand t
Hi
Respected postgres community members
I have created BRIN index on few columns of the table without any issues.
But i am unable to create BRIN index on one column of the table as i got
error listed below
[local]:6263 postgres@huawei=# CREATE INDEX brin_idx on huawei using brin
("dFetch");
ERRO
From: Durgamahesh Manne [mailto:maheshpostgr...@gmail.com]
Sent: Wednesday, September 19, 2018 9:43 AM
To: PostgreSQL mailing lists
Subject: Regrading brin_index on required column of the table
WARNING: This email originated from outside of Perceptron! Please be mindful of
PHISHING and MALWARE
Hi
Respected postgres community members
I have created BRIN index on few columns of the table without any issues.
But i am unable to create BRIN index on one column of the table as i got
error listed below
[local]:6263 postgres@huawei=# CREATE INDEX brin_idx on huawei using brin
("dFetch");
ERRO
On 9/19/18 5:40 AM, ncontu wrote:
Hi Fabio,
It used to work before, even without installing updates.
Exactly, the suspicion is that something in the updates changed the
behavior of your system.
I got two interfaces : private IP and localhost
Selinux is disabled.
I tried installing it from
Sorry,
So basically what I'm trying to achieve is the following. There is an input
file from the user and a configuration describing what is being inserted.
For example, he might have Last activity which is '-MM-DD HH:mi:ss' and
Join date which is only '-MM-DD' because there is no associate
On 9/19/18 6:11 AM, Gabriel Furstenheim Milerud wrote:
I'm not completely sure that that actually works
SELECT to_number('9,134','9V3') =9
SELECT (to_number('9,134', '9')/1000)::numeric(4,3);
numeric
-
9.134
It's true when it should be false (it should be 9.134). Also it is
I see a CoC as an infiltration of the PostgreSQL community which has worked
OK since at least 10 years.
The project owners have let their care slacken.
I request that the project owners EXPEL/EXCOMMUNICATE ALL those who are
advancing what can only be seen as an instrument for harassing members of a
I'm not completely sure that that actually works
SELECT to_number('9,134', '9V3') = 9
It's true when it should be false (it should be 9.134). Also it is
completely dependent on the number of digits. So for example:
SELECT to_number('19,134', '9V3')
Is 1, not 19.134 or even 19
On Wed, 1
First of all, my local system which has postgres_fdw installed is this
version:
PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit
Here are my server configurations (I have tweaked these with no improvement
to my issue):
- fetch_size=100
- fdw_startup_cost=1000
On 9/19/18 5:38 AM, Gabriel Furstenheim Milerud wrote:
Hello,
I'd like to convert a string number to a number being able to provide
the custom format.
With dates it works perfectly fine, so that I can do:
SELECT to_date('18 09 10', 'YY MM DD')
Is there something similar with numbers?
SELECT
Hi Fabio,
It used to work before, even without installing updates.
I got two interfaces : private IP and localhost
Selinux is disabled.
I tried installing it from source, from git repo. Can't find the RPM, do you
have any link for centos7?
I tried both /etc/init.d and command line, same issue.
T
Hello,
I'd like to convert a string number to a number being able to provide the
custom format.
With dates it works perfectly fine, so that I can do:
SELECT to_date('18 09 10', 'YY MM DD')
Is there something similar with numbers?
SELECT to_number('9,000', some_format) = 9;
SELECT to_numb
Le 19/09/2018 à 05:29, Thomas Munro a écrit :
> On Wed, Sep 19, 2018 at 1:35 PM jimmy wrote:
>> I use select pg_prewarm('table1','read','main') to load data of table1 into
>> the memory.
>> when I use select count(1) from table1 group by aa to query data.
>> I find the speed of query is not fast
@Thomas, this tool looks very interesting!
@Jimmy:
Back to the question,you might approach the problem from a different
perspective..
If you run a query 2 consecutive times, from the secondon, you should be at
'full speed'.
Therefore if the first run takes X seconds but the consecutive runs t
45 matches
Mail list logo
