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  1612 
Alex <al**@meerkatso ft.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**@meerkatso ft.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**@meerkatso ft.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 YourEmailAddres sHere" to ma*******@postg resql.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**@meerkatso ft.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 YourEmailAddres sHere" to ma*******@postg resql.org)
UNSUBSCRIBE
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.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 virtual primary key, it is slow;
when there is no virtual primary key, it scrolls quickly.
Looking at Profiler, I see that when there is no virtual primary key, Access
sends a simple select command to SQL Server. However, when there is a
virtual...
|
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; j++) {
buffer = String.Concat(buffer, "x");
// I tried buffer += "x"; same performance
}
|
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 streams. I ran
the test for 50K, 100K, 500K iterations, where each iteration consists
of sending an object from a client process to a server process, and the
server process sends back an ack.
Here are the results:
.NET Remoting C++...
|
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 I get very
slow performance (20-30 second delay). The add to table works but I
get slow performance. Any record adds or deletes after this first add
are fast. It does not seem to matter which table the record add
occurs. I get slow...
|
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:
#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------
| | |
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 correct it.
For purposes of explanation, lets say I have two tables: tblIssues and
tblLocationHistory. The tblIssues table contains 'incidents' along with
the incident header information. The tblLocationHistory table contains
a list of all...
|
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 standard (I
think!);
e.g:
# get connection
loop
|
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 Domain.
We have both Cold Fusion and ASP.NET apps on this server and the Cold Fusion
apps do not display such slowness on their first start up of the day. Is
there a way to improve the load times of ASP.NET apps?
I'm having to justify to my boss...
|
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 opportunity to test some new features of Access2007 before actually 'stepping over'.
First thing that troubles me of course is 'the ribbon', but my question now is about speed.
I opened one of my Access 2000-apps in Access 2007.
Speed and...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
