Re: Need support

2024-10-25 Thread Adrian Klaver
On 10/24/24 20:13, 侯海军Cole wrote: Hello, postgresql. I've encountered some technical situations when using it, and I need to discuss it with other or postgresql officials. But I can't join Libera Chat, what's going on? The message under Libre.Chat and above the login tells you why. Short vers

Re: Need support

2024-10-25 Thread Daniel Gustafsson
> On 25 Oct 2024, at 05:13, 侯海军Cole wrote: > > Hello, postgresql. I've encountered some technical situations when using it, > and I need to discuss it with other or postgresql officials. But I can't join > Libera Chat, what's going on? The postgres project are not affiliated with Libera Chat i

Re: Need support on tuning at the time of index creation

2020-02-01 Thread Peter J. Holzer
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

RE: Need support on tuning at the time of index creation

2020-01-31 Thread Sandip Pradhan
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

RE: Need support on tuning at the time of index creation

2020-01-31 Thread Sandip Pradhan
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

Re: Need support on tuning at the time of index creation

2020-01-31 Thread Jayadevan M
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

RE: Need support on tuning at the time of index creation

2020-01-31 Thread Sandip Pradhan
-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

Re: Need support on tuning at the time of index creation

2020-01-27 Thread Peter J. Holzer
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

Re: Need support on tuning at the time of index creation

2020-01-27 Thread github kran
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

Re: Need support on tuning at the time of index creation

2020-01-27 Thread Ron
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