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

From Kevin Grittner
Subject Re: Select * is very slow
Date
Msg-id 4CD7DA3B02000025000373DD@gw.wicourts.gov
Whole thread Raw
In response to Select * is very slow  ("shaiju.ck" <shaiju.ck@gmail.com>)
List pgsql-performance
"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?

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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Select * is very slow
Next
From: Thomas Kellerer
Date:
Subject: Re: Select * is very slow