"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? Did you signal PostgreSQL to "reload" its configuration after making the change? Oh, and please show us the result of running `select version();` and tell us about the hardware and OS. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
