On Mon, Nov 8, 2010 at 1:16 AM, shaiju.ck <shaiju.ck@xxxxxxxxx> wrote: > [....] I have increased the shared_buffres to 1024MB, but no > improvement. I have noticed that the query "show shared_buffers" always show > 8MB.Why is this? Does it mean that changing the shared_buffers in config > file have no impact? Can anybody help? Shaiju Have you restarted PostgreSQL? Changing that setting requires a complete restart for it to take effect. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
