Postgres Pro
Downloads
Home   >   mailing lists

Re: How to improve insert speed with index on text column - Mailing list pgsql-performance

From Saurabh
Subject Re: How to improve insert speed with index on text column
Date
Msg-id 94613a40-9ed8-403f-b7ce-92cfd50b81d3@o20g2000yqh.googlegroups.com
Whole thread Raw
In response to How to improve insert speed with index on text column  (Saurabh <saurabh.b85@gmail.com>)
Responses Re: How to improve insert speed with index on text column  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: CSS
Date:
Subject: rough benchmarks, sata vs. ssd
Next
From: "Tomas Vondra"
Date:
Subject: Re: How to improve insert speed with index on text column