Re: [GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Thomas Beutin
On Tue, Jan 06, 2004 at 12:50:05AM +0900, Alex wrote: > Yup, DMA is not enabled, probably that is the problem. Tried to enable > it but get an error HDIO_SET_DMA failed: Operation not permitted. probably You have no support for Your boards chipset enabled. You can do this ether by loading the pro

Re: [GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Alex
Yup, DMA is not enabled, probably that is the problem. Tried to enable it but get an error HDIO_SET_DMA failed: Operation not permitted. Thanks for the hint. Alex Doug McNaught wrote: Alex <[EMAIL PROTECTED]> writes: The old system has a 80GB, 5200rpm ATA , the new system a 120GB, 7200rpm A

Re: [GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Doug McNaught
Alex <[EMAIL PROTECTED]> writes: > The old system has a 80GB, 5200rpm ATA , the new system a 120GB, > 7200rpm ATA. The new system should at least not be slower. Also, on > the new system I have a separate partition for the database. > > If I run a Vacuum or a SELECT COUNT(*) on a larger table (2-6

Re: [GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Alex
The old system has a 80GB, 5200rpm ATA , the new system a 120GB, 7200rpm ATA. The new system should at least not be slower. Also, on the new system I have a separate partition for the database. If I run a Vacuum or a SELECT COUNT(*) on a larger table (2-6 million records) the systems responds v

Re: [GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Doug McNaught
Alex <[EMAIL PROTECTED]> writes: > Hi, > I just installed pg 7.4.1 on a new system P4, 3.2Gh HT, 1GB Mem, RH9 > and discovered that some of the processes have become extremely > slow. Mainly I am talking about a SELECT COUNT(*) or VACUUM. > > Before running the same database on a P4. 2Ghz 412MB me

[GENERAL] Slow Performance with 7.4.1

2004-01-05 Thread Alex
Hi, I just installed pg 7.4.1 on a new system P4, 3.2Gh HT, 1GB Mem, RH9 and discovered that some of the processes have become extremely slow. Mainly I am talking about a SELECT COUNT(*) or VACUUM. Before running the same database on a P4. 2Ghz 412MB mem, I got the job done in some cases half t