On Thu, 4 Feb 2010, Amitabh Kant wrote:
On Wed, Feb 3, 2010 at 10:05 PM, Ivan Voras wrote:
If you can, add another 2 drives in RAID 1 and move+symlink the pg_xlog
directory to the new array.
Can't do anything about this server now, but would surely keep in mind
before upgrading other servers.
On Thu, Feb 4, 2010 at 3:29 AM, Greg Smith wrote:
> Robert Haas wrote:
>
> On Wed, Feb 3, 2010 at 10:10 AM, Amitabh Kant
> wrote:
>
>
> work_mem = 160MB # pg_generate_conf wizard 2010-02-03
>
>
> Overall these settings look sane, but this one looks like an
> exception. That is an enormous
On Thu, Feb 4, 2010 at 3:10 PM, Ivan Voras wrote:
> On 4 February 2010 10:02, Amitabh Kant wrote:
> > On Wed, Feb 3, 2010 at 10:05 PM, Ivan Voras wrote:
> >>
> >> On 02/03/10 16:10, Amitabh Kant wrote:
> >>>
> >>> Hello
> >>>
> >>> I have a server dedicated for Postgres with the following specs
On 4 February 2010 10:02, Amitabh Kant wrote:
> On Wed, Feb 3, 2010 at 10:05 PM, Ivan Voras wrote:
>>
>> On 02/03/10 16:10, Amitabh Kant wrote:
>>>
>>> Hello
>>>
>>> I have a server dedicated for Postgres with the following specs:
>>>
>>> RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xe
On Thu, Feb 4, 2010 at 12:11 AM, Andy Colson wrote:
> On 2/3/2010 9:10 AM, Amitabh Kant wrote:
>
>> Hello
>>
>> I have a server dedicated for Postgres with the following specs:
>>
>> RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @
>> 2.33GHz
>> OS: FreeBSD 8.0
>>
>> It runs
On Wed, Feb 3, 2010 at 10:05 PM, Ivan Voras wrote:
> On 02/03/10 16:10, Amitabh Kant wrote:
>
>> Hello
>>
>> I have a server dedicated for Postgres with the following specs:
>>
>> RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @
>> 2.33GHz
>> OS: FreeBSD 8.0
>>
>
> If you re
Robert Haas wrote:
On Wed, Feb 3, 2010 at 10:10 AM, Amitabh Kant wrote:
work_mem = 160MB # pg_generate_conf wizard 2010-02-03
Overall these settings look sane, but this one looks like an
exception. That is an enormous value for that parameter...
Yeah, I think I need to retune th
On Wed, Feb 3, 2010 at 10:10 AM, Amitabh Kant wrote:
> work_mem = 160MB # pg_generate_conf wizard 2010-02-03
Overall these settings look sane, but this one looks like an
exception. That is an enormous value for that parameter...
...Robert
--
Sent via pgsql-performance mailing list (pgsql-perf
On 2/3/2010 9:10 AM, Amitabh Kant wrote:
Hello
I have a server dedicated for Postgres with the following specs:
RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @
2.33GHz
OS: FreeBSD 8.0
It runs multiple (approx 10) databases ranging from 500MB to over 24 GB
in size. All of
On 02/03/10 16:10, Amitabh Kant wrote:
Hello
I have a server dedicated for Postgres with the following specs:
RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @
2.33GHz
OS: FreeBSD 8.0
If you really do have "heavy read and write" load on the server, nothing
will save you
Hello
I have a server dedicated for Postgres with the following specs:
RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @
2.33GHz
OS: FreeBSD 8.0
It runs multiple (approx 10) databases ranging from 500MB to over 24 GB in
size. All of them are of the same structure, and almost
11 matches
Mail list logo