Postgres Pro
Downloads
Home   >   mailing lists

Re: Select * is very slow - Mailing list pgsql-performance

From Justin Pitts
Subject Re: Select * is very slow
Date
Msg-id AANLkTi=-ZGrpp5mokg-ycLi=GTHxUYLZdcy2Da5jYaFp@mail.gmail.com
Whole thread Raw
In response to Select * is very slow  ("shaiju.ck" <shaiju.ck@gmail.com>)
List pgsql-performance
Tree view 
On Mon, Nov 8, 2010 at 1:16 AM, shaiju.ck <shaiju.ck@gmail.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.

pgsql-performance by date:

Previous
From: "Pierre C"
Date:
Subject: Re: Select * is very slow
Next
From: Klaus Ita
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences