Re: [PERFORM] updating a row in a table with only one row

2009-10-12 Thread Michal Vitecek
Merlin Moncure wrote: >On Tue, Oct 6, 2009 at 10:59 AM, Michal Vitecek wrote: >> Merlin Moncure wrote: >>>On Mon, Oct 5, 2009 at 5:17 AM, Michal Vitecek wrote: >>> >>>>  Could the problem be the HW RAID card? There's ServerRAID 8k with 256MB >>

Re: [PERFORM] updating a row in a table with only one row

2009-10-06 Thread Michal Vitecek
Merlin Moncure wrote: >On Mon, Oct 5, 2009 at 5:17 AM, Michal Vitecek wrote: > >>  Could the problem be the HW RAID card? There's ServerRAID 8k with 256MB >>  with write-back enabled. Could it be that its internal cache becomes >>  full and all disk I/O operations ar

Re: [PERFORM] updating a row in a table with only one row

2009-10-05 Thread Michal Vitecek
Robert Haas wrote: >On Fri, Oct 2, 2009 at 9:54 AM, Merlin Moncure wrote: >> On Fri, Oct 2, 2009 at 4:18 AM, Michal Vitecek wrote: >>>  Hello everyone, >>> >>>  I'm using PostgreSQL 8.3.8 running on a server with 2 Xeon CPUs, 4GB >>>  RAM, 4+

[PERFORM] updating a row in a table with only one row

2009-10-02 Thread Michal Vitecek
Hello everyone, I'm using PostgreSQL 8.3.8 running on a server with 2 Xeon CPUs, 4GB RAM, 4+2 disks in RAID 5 and CentOS 5.3. There's only one database which dumped with pgdump takes ~0.5GB. There are ~100 tables in the database and one of them (tableOne) always contains only a single row.