pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tomas Vondra <tv@fuzzy.cz>
To: Saurabh <saurabh.b85@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve insert speed with index on text column
Date: Tue, 31 Jan 2012 12:21:38 +0100
Message-ID: <21d33cd6ba3c80ad896633820f6b27ed.squirrel@sq.gransy.com> (raw)
In-Reply-To: <94613a40-9ed8-403f-b7ce-92cfd50b81d3@o20g2000yqh.googlegroups.com>
References: <bdd5c927-eeb7-46ed-a9a6-231b731f37e8@t15g2000yqi.googlegroups.com>
	<CAMkU=1yfqP=HCpYQg3Pe+x-ZynC-egBnkSQ2dUUNOmt8D6wCPA@mail.gmail.com>
	<c67d3789-74c8-4b20-aa2b-451ca0649f71@kn4g2000pbc.googlegroups.com>
	<CAMkU=1xUVrz9reeUgXGQYht12WPaf4yEBoX-rKa5kAq-u0jE5A@mail.gmail.com>
	<94613a40-9ed8-403f-b7ce-92cfd50b81d3@o20g2000yqh.googlegroups.com>

On 31 Leden 2012, 10:29, Saurabh wrote:
> 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?

Shared buffers is the cache maintained by PostgreSQL. All all the data
that you read/write need to go through shared buffers.

Maintenance_work_mem specifies how much memory can "maintenance tasks"
(e.g. autovacuum, reindex, etc.) use. This is similar to work_mem for
common queries (sorting, grouping, ...).

Tomas

view thread (19+ messages)  latest in thread

Message-ID: <21d33cd6ba3c80ad896633820f6b27ed.squirrel@sq.gransy.com>
Permalink:  ../21d33cd6ba3c80ad896633820f6b27ed.squirrel@sq.gransy.com/
Also on:    postgresql.org/message-id/21d33cd6ba3c80ad896633820f6b27ed.squirrel@sq.gransy.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tv@fuzzy.cz, saurabh.b85@gmail.com
  Subject: Re: How to improve insert speed with index on text column
  In-Reply-To: <21d33cd6ba3c80ad896633820f6b27ed.squirrel@sq.gransy.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox