Thanks everyone for your response. I will try these settings.
On Tue, Jun 2, 2015 at 1:28 PM, Graeme B. Bell
wrote:
> > I believe yes / 0 are the default settings for synchronous commit and
> commit_delay. ** (Interestingly the manual pages do not specify.) **
>
> Sorry, I've just spotted the
> On 05/30/2015 09:46 AM, Ashik S L wrote:
>> We are using postgres SQL version 8.4.17..
>> Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
>> each row is of 60 bytes.Every time we insert 16380 bytes of data.
>
> Way back when, I was inserting a lo
postgres.conf file:
shared_buffers = 512MB // It was 32MB
work_mem = 30MB
effective_cache_size = 512MB // I tried with 128MB 256MB also
Please let me know any config changes that I can try out.
Thanks,
Ashik
On 5/30/15, Tomas Vondra wrote:
>
>
> On 05/29/15 20:10, Ashik S L wrote:
Hi All,
I am using postgresDB on redhat machine which is having 4GB RAM
machine. As soon as it starts to Inserting rows into the postgres DB it
will reach 100%cpu. It will comedown to normal after 40 minutes. I tried perform
some tuning on the postgres DB, But result was same.I am not postgres
DB
Hi All,
I am using postgresDB on redhat machine which is having 4GB RAM
machine. As soon as it starts to Inserting rows into the postgres DB it
will reach
100%cpu. It will comedown to normal after 40 minutes. I tried perform
some tuning on the postgres DB, But result was same.I am not postgres
DB
