On 2020-01-31 10:13:20 +, Sandip Pradhan wrote:
> Thanks for your time.
>
> Out Postgresql version: 9.5.9.14.
>
> We are using COPY command to insert rows into the tables. While running COPY
> command, all indexes dropped.
>
So I take it that the copy is fast, but the building of indexes i
nt: Tuesday, January 28, 2020 4:16 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: Need support on tuning at the time of index creation
On 2020-01-27 11:10:36 +, Sandip Pradhan wrote:
> One of our ericsson product used backend db as postgresql 9. We are
> facing following performan
SEZ Block 1A, Rajarhat
700156, Kolkata, West Bengal
India
ericsson.com<http://www.ericsson.com/>
From: Jayadevan M
Sent: Friday, January 31, 2020 3:30 PM
To: Sandip Pradhan
Cc: Ron ; pgsql-general@lists.postgresql.org
Subject: Re: Need support on tuning at the time of index creation
On
On Fri, Jan 31, 2020 at 3:22 PM Sandip Pradhan
wrote:
> Hi Ron,
>
> Thanks for your time.
>
> We are using the version 9.5.9.14.
>
May be you could try tweaking maintenance_work_mem?
Regards,
Jayadevan
-Original Message-
From: Ron
Sent: Monday, January 27, 2020 4:57 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Need support on tuning at the time of index creation
On 1/27/20 5:10 AM, Sandip Pradhan wrote:
> Dear Sir/Madam,
>
> One of our ericsson product used backend db as postgre
On 2020-01-27 11:10:36 +, Sandip Pradhan wrote:
> One of our ericsson product used backend db as postgresql 9. We are facing
> following performance issues where we need some support from your side.
> We are having 10 tables and we are inserting around 150 million to 250 million
> records on ea
On Mon, Jan 27, 2020 at 5:27 AM Ron wrote:
> On 1/27/20 5:10 AM, Sandip Pradhan wrote:
> > Dear Sir/Madam,
> >
> > One of our ericsson product used backend db as postgresql 9. We are
> facing
> > following performance issues where we need some support from your side.
> > We are having 10 tables a
On 1/27/20 5:10 AM, Sandip Pradhan wrote:
Dear Sir/Madam,
One of our ericsson product used backend db as postgresql 9. We are facing
following performance issues where we need some support from your side.
We are having 10 tables and we are inserting around 150 million to 250
million records on
