Skip site navigation (1) Skip section navigation (2)

Re: How to improve insert speed with index on text column

From: Saurabh <saurabh(dot)b85(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to improve insert speed with index on text column
Date: 2012-01-31 09:29:35
Message-ID: 94613a40-9ed8-403f-b7ce-92cfd50b81d3@o20g2000yqh.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-performance
I changed the configuration in postgresql.conf. Following are the
changed parameters:

shared_buffers = 1GB
maintenance_work_mem = 50MB
checkpoint_segments = 64
wal_buffers = 5MB
autovacuum = off

Insert the records in the database and got a very good performance it
is increased by 6 times.

Can you please tell me the purpose of shared_buffer and
maintenance_work_mem parameter?

Thanks,
Saurabh

In response to

Responses

pgsql-performance by date

Next:From: Tomas VondraDate: 2012-01-31 11:21:38
Subject: Re: How to improve insert speed with index on text column
Previous:From: CSSDate: 2012-01-31 08:07:51
Subject: rough benchmarks, sata vs. ssd

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group