Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group