Re: Select * is very slow

From: Justin Pitts <justinpitts(at)gmail(dot)com>
To: "shaiju(dot)ck" <shaiju(dot)ck(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Select * is very slow
Date: 2010-11-08 15:37:36
Message-ID: AANLkTi=-ZGrpp5mokg-ycLi=GTHxUYLZdcy2Da5jYaFp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 8, 2010 at 1:16 AM, 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? Can anybody help? Shaiju

Have you restarted PostgreSQL? Changing that setting requires a
complete restart for it to take effect.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri Fontaine 2010-11-08 15:57:14 Re: Running PostgreSQL as fast as possible no matter the consequences
Previous Message Thom Brown 2010-11-08 15:30:30 Re: Select * is very slow