Hi,
In addition, when you have multiple hard drive, it needs to be considered to
put a database cluster and wal files separately on different spindles (hard
drives), because of different I/O charasteristics, in particular update
intensive workload.
Generally speaking, having 4 disks, one RAID-
On Thu, Dec 22, 2011 at 11:18 PM, tuanhoanganh wrote:
> Thanks for your answer. But how performance between raid5 and one disk.
One disk will usually win, 2 disks (in a mirror) will definitely win.
RAID-5 has the highest overhead and the poorest performance,
especially if it's degraded (1 drive o
Thanks for your answer. But how performance between raid5 and one disk.
Please help me.
Thanks in advance
Tuan Hoang Anh
On Fri, Dec 23, 2011 at 11:00 AM, Scott Marlowe wrote:
> On Thu, Dec 22, 2011 at 8:55 PM, Scott Marlowe
> wrote:
> > On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh
> wrote:
On Thu, Dec 22, 2011 at 8:55 PM, Scott Marlowe wrote:
> On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh wrote:
>> I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
>> Windows 2003 64bit
>> I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
>> bestter than
On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh wrote:
> I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
> Windows 2003 64bit
> I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
> bestter than 3 disk independent or not.
>
> Here is my pgbench -h %HOST%
I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
Windows 2003 64bit
I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
bestter than 3 disk independent or not.
Here is my pgbench -h %HOST% -p 5433 -U postgres -c 10 -T 1800 -s 10
pgbench
pgbench -h 127.0
Yes, perhaps it is related to it, and the cause is the same. But they
mention here a special type inet.
Best regards,
Otto
2011/12/22 Rafael Martinez
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 12/22/2011 12:29 AM, Havasvölgyi Ottó wrote:
> > Hello,
> >
> > Can you find some relati
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/22/2011 12:29 AM, Havasvölgyi Ottó wrote:
> Hello,
>
> Can you find some relation between the memory usage and insert
> statements? 9.1.2 has memory problems with inserts (even the simplest
> ones) on Linux and Windows too, I could produce it. U
SOLVED
On Tue, Dec 20, 2011 at 3:46 PM, Tom Lane - t...@sss.pgh.pa.us
<+nabble+miller_2555+c5a65c2e1a.tgl#sss.pgh.pa...@spamgourmet.com>
wrote:
> nabble.30.miller_2...@spamgourmet.com writes:
>> I've run EXPLAIN on the query, but AFAICS the query plan does not
>> appear significantly different than
On Tue, Dec 20, 2011 at 11:15 AM, F. BROUARD / SQLpro -
sql...@club-internet.fr
<+nabble+miller_2555+ca434688eb.sqlpro#club-internet...@spamgourmet.com>
wrote:
> I should think your query is not correct.
>
> Le 19/12/2011 16:52, nabble.30.miller_2...@spamgourmet.com a écrit :
>>
>> SELECT "bigint",
On Wed, Dec 21, 2011 at 6:30 PM, Benjamin Johnson
wrote:
> Jeff,
>
> Sorry for the delayed response. Please see (some) answers inline.
>
> On 12/1/2011 9:06 AM, Jeff Janes wrote:
>> On Wed, Nov 30, 2011 at 7:27 AM, Benjamin Johnson
>> Why shove it in as fast as you can? If you want to both read
11 matches
Mail list logo
