Re: Select * is very slow

Поиск
Список
Период
Сортировка
От Justin Pitts
Тема Re: Select * is very slow
Дата
Msg-id AANLkTi=-ZGrpp5mokg-ycLi=GTHxUYLZdcy2Da5jYaFp@mail.gmail.com
обсуждение исходный текст
Ответ на Select * is very slow  ("shaiju.ck" <shaiju.ck@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Pierre C"
Дата:
Сообщение: Re: Select * is very slow
Следующее
От: Klaus Ita
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences