Re: Setting Shared-Buffers
| От | Rafael Domiciano |
|---|---|
| Тема | Re: Setting Shared-Buffers |
| Дата | |
| Msg-id | 3a0028490907201339l790a0c4fm4520c276b6821e2d@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Setting Shared-Buffers (Scott Marlowe <scott.marlowe@gmail.com>) |
| Список | pgsql-admin |
Hello People,
I upgraded to a 64 bits System. Now, everything is OK. Thnk you guys.
On Sat, Jul 11, 2009 at 2:19 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Fri, Jul 10, 2009 at 10:27 PM, <sriram.dandapani@bt.com> wrote:For you, yes. But not necessarily for others.
>
> 2G per process is plenty ...and useful if you have large data warehouse style queries which are long running (especially multiple of those)Definitely.
> We do benefit from the Linux memory caching model regardless of what Postgres uses right ?I bet you'd see another big performance improvement with a 64bit OS
> On a machine which we upgraded from 4G to 16G on a 32 bit PAE kernel...we saw a doubling of performance for most queries of a certain type.(mostly data warehouse type accessing several hundreds of thousands of records).
>
> Postgres version that we use is 8.1.9.
and pgsql AND an upgrade to 8.4. But if it's fast enough, then stick
to 8.1.x I would recommend an update to the latest 8.1 release
though.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
В списке pgsql-admin по дате отправления: