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 the time.
The weird thing however is, that normal inserts seem to be much faster
on the new system and I am wondering if it is Postgres or HW related.
Does anyone has an advise ?
Thanks
Alex
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster 7 1594
Alex <al**@meerkatsoft.com> 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 mem, I got the job done in some cases half the time.
The weird thing however is, that normal inserts seem to be much faster on the new system and I am wondering if it is Postgres or HW related.
Does anyone has an advise ?
What kind of disk hardware is on the two systems?
-Doug
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
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 very slow, the screen almost freezes.
Thanks
Alex
Doug McNaught wrote: Alex <al**@meerkatsoft.com> 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 mem, I got the job done in some cases half the time.
The weird thing however is, that normal inserts seem to be much faster on the new system and I am wondering if it is Postgres or HW related.
Does anyone has an advise ?
What kind of disk hardware is on the two systems?
-Doug
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Alex <al**@meerkatsoft.com> 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 million records) the systems responds very slow, the screen almost freezes.
Sounds like you may not have DMA enabled on the newer machine, or
there is some other kernel problem that slows the disk down. You
might try running Bonnie or a similar disk benchmark to make sure you
are getting the right disk performance.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
unsubscribe
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
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 <al**@meerkatsoft.com> 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 million records) the systems responds very slow, the screen almost freezes.
Sounds like you may not have DMA enabled on the newer machine, or there is some other kernel problem that slows the disk down. You might try running Bonnie or a similar disk benchmark to make sure you are getting the right disk performance.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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 proper module or compiling this
into Your kernel.
Hope this helps.
Greetings,
-tb
--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
UNSUBSCRIBE
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Neil |
last post by:
I've been discussing here a SQL 7 view which scrolls slowly when linked to
an Access 2000 MDB. After trying various things, I've distilled it down to
the following: when the linked view has a...
|
by: BlueBall |
last post by:
I am writing some kind of network testing tool and I have wrote the
following code in ASP.NET with C#
int size= 10048576; // around 10 MB data
string buffer = "";
for (int j=1; j<=1024;...
|
by: ajou_king |
last post by:
I was running some tests on my Win32 1GHZ processor to see how long it
would take to transmit objects numerous times via TCP/IP using C#
..NET Remoting vs the C++ trustworthy method of binary...
|
by: jdipalmajr |
last post by:
I am using a strongly typed dataset with a design time schema. I load
data into the dataset tables from xml. The problem I am having is
after the XML load. The first time I Add a row to a table...
|
by: Mario Soto |
last post by:
Hi. i hava a postresql 7.4.2 in a production server.
tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0.
The postresql.conf say:
...
|
by: frankgerlach |
last post by:
>From my simple performance tests of SOAP it seems that it is about ten
times slower than binary object request protocols such as RMI, IIOP or
SimpleORB.
Is this also YOUR experience ?
|
by: Andy_Khosravi |
last post by:
I'm having a problem trying to optimize the performance of one of my
A97 databases. I have very slow record navigation after a change I made
to the table structure, and I'm not sure how best to...
|
by: dan |
last post by:
within a loop i am building a sql insert statement to run against my
(programatically created) mdb. it works but it seems unreasonably SLOW!
Sorry, dont have the code here but the jist is very...
|
by: SAL |
last post by:
I have an ASP.NET 2.0 app that takes about 17 seconds to load on first
startup but then is very fast after that. As I understand it from some posts
in June, this is caused by the loading of the App...
|
by: Arno R |
last post by:
Hi all,
So I bought a new laptop 10 days ago to test my apps with Vista. (home premium)
Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1)
So I take the...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |