On Thu, Apr 2, 2020 at 11:38 PM Andrus wrote:
> Hi!
>
> >Simply replace
> > SET col = unnest(array_value)
> >with
> >
> > SET col = array_value[1]
>
> I tried
>
>
> update temprid set
> ContactFirstName =xpath(
>
>
> '/E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactF
James Brauman writes:
> I am using the COPY command to insert 10 million rows from a CSV file
> into a database table and I am finding the performance is
> unacceptable. When the COPY command is executed the disk I/O is
> extremely high which leads to degraded query performance for other
> quer
On Fri, 2020-04-03 at 18:27 +1100, Tim Cross wrote:
> > I am using the COPY command to insert 10 million rows from a CSV file
> > into a database table and I am finding the performance is
> > unacceptable. When the COPY command is executed the disk I/O is
> > extremely high which leads to degraded
On Fri, 2020-04-03 at 00:59 -0400, AC Gomez wrote:
> Granted. But we are where we are, so I'm assuming this is going to be hand to
> hand combat.
Yes, unfortunately there is no better way.
But DROP ROLE will produce messages that help you along.
Yours,
Laurenz Albe
--
Cybertec | https://www.cyb
Hi Adrian, Thanks for your response. Here is what I'm getting when I run
pg_config;
$ pg_configBINDIR = /usr/binDOCDIR = /usr/share/doc/pgsqlHTMLDIR =
/usr/share/doc/pgsqlINCLUDEDIR = /usr/includePKGINCLUDEDIR =
/usr/include/pgsqlINCLUDEDIR-SERVER = /usr/include/pgsql/serverLIBDIR =
/usr/lib64P
> On Apr 3, 2020, at 2:50 AM, Laurenz Albe wrote:
>
> On Fri, 2020-04-03 at 00:59 -0400, AC Gomez wrote:
>> Granted. But we are where we are, so I'm assuming this is going to be hand
>> to hand combat.
>
> Yes, unfortunately there is no better way.
> But DROP ROLE will produce messages that
On Fri, Apr 3, 2020 at 5:17 AM Rajiv Ranjan wrote:
> Does this unnamed monitoring tool (and undefined query) really think
> higher percentages are worse or are you mis-communicating?
>
> Forget about the tool used for monitoring, important is to monitor the
> "Cache hit ratio" is good or we can i
On 4/3/20 5:53 AM, Moses Mafusire wrote:
Hi Adrian,
Thanks for your response. Here is what I'm getting when I run /pg_config;/
VERSION = PostgreSQL 12.1
So that is the correct version.
Just to be clear there is only one version of Postgres on this machine,
correct?
Before you run make ag
On 4/2/20 9:42 PM, James Brauman wrote:
I am using the COPY command to insert 10 million rows from a CSV file
into a database table and I am finding the performance is
unacceptable. When the COPY command is executed the disk I/O is
extremely high which leads to degraded query performance for othe
On 4/3/20 9:52 AM, Adrian Klaver wrote:
On 4/2/20 9:42 PM, James Brauman wrote:
I am using the COPY command to insert 10 million rows from a CSV file
into a database table and I am finding the performance is
unacceptable. When the COPY command is executed the disk I/O is
extremely high which
Hi Adrian,Yes VERSION = PostgreSQL 12.1, is the only version I have. So I am
novice to Linux and Postgres, where should I run this ifndef MAJORVERSION
MAJORVERSION := $(basename $(VERSION))
endif
$(info MAJORVERSION is $(MAJORVERSION))
and do I run as is or do I need to do something else, if
If you didn't turn it off, you have parallel workers on by default with
v12. If work_mem is set high, memory use may be much higher as each node in
a complex plan could end up executing in parallel.
Also, do you use a connection pooler such as pgbouncer or pgpool? What is
max_connections set to?
Does this unnamed monitoring tool (and undefined query) really think higher
percentages are worse or are you mis-communicating?
Forget about the tool used for monitoring, important is to monitor the
"Cache hit ratio" is good or we can ignore it?
On Wed, 1 Apr 2020 at 10:44, David G. Johnston
wr
On 4/3/20 9:26 AM, Moses Mafusire wrote:
Hi Adrian,
Yes VERSION = PostgreSQL 12.1, is the only version I have. So I am
novice to Linux and Postgres, where should I run this
/ifndef MAJORVERSION
MAJORVERSION := $(basename $(VERSION))
endif
$(info MAJORVERSION is $(MAJORVERSION))/
and do I
On 4/2/20 9:59 PM, AC Gomez wrote:
Granted. But we are where we are, so I'm assuming this is going to be
hand to hand combat.
Well you could even the odds somewhat by using the below as a starting
point:
SELECT
relname,
pg_roles.rolname,
acl.*
FROM
pg_class,
aclexplode(r
On 4/3/20 10:18 AM, Adrian Klaver wrote:
On 4/2/20 9:59 PM, AC Gomez wrote:
Granted. But we are where we are, so I'm assuming this is going to be
hand to hand combat.
Well you could even the odds somewhat by using the below as a starting
point:
SELECT
relname,
pg_roles.rolname,
yeah I'm on 9.5, but thanks for the info.
On Fri, Apr 3, 2020 at 1:24 PM Adrian Klaver
wrote:
> On 4/3/20 10:18 AM, Adrian Klaver wrote:
> > On 4/2/20 9:59 PM, AC Gomez wrote:
> >> Granted. But we are where we are, so I'm assuming this is going to be
> >> hand to hand combat.
> >
> > Well you co
Adrian,I really appreciate your help. I was able to open the file in a text
editor in centOS, but it's read-only. I cannot even replace the file. Any
tricks up your sleeves for me to edit this file.
Thanks
Moses
On Friday, April 3, 2020, 12:40:19 PM EDT, Adrian Klaver
wrote:
On 4/3/20
On 4/3/20 10:48 AM, Moses Mafusire wrote:
Adrian,
I really appreciate your help. I was able to open the file in a text
editor in centOS, but it's read-only. I cannot even replace the file.
Any tricks up your sleeves for me to edit this file.
Looks like a permissions issue.
In your first post
I actually started the installation process as me. I was logged as user
postgres because after trying and getting that version error message. I thought
as user postgres I would be able to install, but failed). I get the same
results though;
[username@dart-centos ~]$ /usr/bin/pg_configBINDIR = /u
On 4/3/20 11:52 AM, Moses Mafusire wrote:
I actually started the installation process as me. I was logged as user
postgres because after trying and getting that version error message. I
thought as user postgres I would be able to install, but failed). I get
the same results though;
Yes, but y
On 4/3/20 11:52 AM, Moses Mafusire wrote:
I actually started the installation process as me. I was logged as user
postgres because after trying and getting that version error message. I
thought as user postgres I would be able to install, but failed). I get
the same results though;
Dawned on
On Thu, Apr 2, 2020 at 9:25 PM Kyotaro Horiguchi
wrote:
> I provided the subject, and added -hackers.
>
> > Hello,
> > I am running postgres 11.5 and we were having issues with shared segments.
> > So I increased the max_connection as suggested by you guys and reduced my
> > work_mem to 600M.
> >
23 matches
Mail list logo
