Re: [pgadmin-support] [GENERAL] Postgres DB crashing

2013-06-20 Thread Merlin Moncure
On Thu, Jun 20, 2013 at 5:17 AM, Richard Huxton wrote: > On 18/06/13 18:31, bhanu udaya wrote: >> >> Hello, >> Greetings. >> >> My PostgresSQL (9.2) is crashing after certain load tests. Currently, >> postgressql is crashing when simulatenously 800 to 1000 threads are run >> on a 10 million record

Re: [pgadmin-support] [GENERAL] Postgres DB crashing

2013-06-20 Thread Richard Huxton
On 18/06/13 18:31, bhanu udaya wrote: Hello, Greetings. My PostgresSQL (9.2) is crashing after certain load tests. Currently, postgressql is crashing when simulatenously 800 to 1000 threads are run on a 10 million records schema. Not sure, if we have to tweak some more parameters of postgres. Cu

Re: [pgadmin-support] [GENERAL] Postgres DB crashing

2013-06-19 Thread bhanu udaya
Thanks for the quick response. These errors are after disabling the autovacuum. auto_vacuum parameter was set to off. Can find the exact reason for this crash. Thanks and Regards Radha Krishna Date: Tue, 18 Jun 2013 13:54:09 -0400 Subject: Re: [pgadmin-support] [GENERAL] Postgres DB crashing

Re: [pgadmin-support] [GENERAL] Postgres DB crashing

2013-06-18 Thread AI Rumman
Stop the autovacuum process and try again. On Tue, Jun 18, 2013 at 1:31 PM, bhanu udaya wrote: > Hello, > Greetings. > > My PostgresSQL (9.2) is crashing after certain load tests. Currently, > postgressql is crashing when simulatenously 800 to 1000 threads are run on > a 10 million records sche