"shaiju.ck" <shaiju(dot)ck(at)gmail(dot)com> 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