Andrew McMillan wrote:
On Thu, 2004-04-08 at 14:13, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
But it should be okay to set the filesystem to journal only its
own metadata. There's no need for it to journal file contents.
Can you set ext2 to journal metadata? I
Andrew McMillan wrote:
On Thu, 2004-04-08 at 14:13, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
But it should be okay to set the filesystem to journal only its own
metadata. There's no need for it to journal file contents.
Can you set ext2 to journal
On Wednesday 07 April 2004 05:00, huang yaqin wrote:
hello
Thanks, you are right.
I use postmaster -o -F to start my PGand performance improved
greatly.
I don't think Tom was recommending turning fsync off. If you have a system
crash/power glitch then the database can become
Hello, Richard Huxton,
You said turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
any improvement. So what can I do?
Does SCSI disk and IDE disk have difference?
On Wed, 7 Apr 2004, huang yaqin wrote:
You said turning fsync off may cause losing data, that's terrible. I use
SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
any improvement. So what can I do?
Make sure you do as much as possible inside one transaction. If you want
doing this. :)
BEGIN;
insert ...
insert ...
insert ...
COMMIT;
Regards,
Steve Butler
- Original Message -
From: huang yaqin [EMAIL PROTECTED]
To: Richard Huxton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 6:56 PM
Subject: Re: [PERFORM] good pc but bad performance
On Wed, 2004-04-07 at 20:56, huang yaqin wrote:
Hello, Richard Huxton,
You said turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
any improvement. So what can I do?
Does
Sending again bacuse of MUA error.. Chose a wrong address in From..:-(
Shridhar
On Wednesday 07 April 2004 17:21, Shridhar Daithankar wrote:
On Wednesday 07 April 2004 16:59, Andrew McMillan wrote:
One thing I recommend is to use ext2 (or almost anything but ext3).
There is no real need
processes, such as
loading an empty server from a file.
/Aaron
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: huang yaqin [EMAIL PROTECTED]; Tom Lane [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 4:33 AM
Subject: Re: [PERFORM] good pc but bad
On Wed, 7 Apr 2004, Andrew McMillan wrote:
On Wed, 2004-04-07 at 20:56, huang yaqin wrote:
Hello, Richard Huxton,
You said turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
any
Bruce Momjian [EMAIL PROTECTED] writes:
scott.marlowe wrote:
There is no real need (or benefit) from having the database on a
journalled filesystem - the journalling is only trying to give similar
sorts of guarantees to what the fsync in PostgreSQL is doing.
Is this true? I was under the
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
scott.marlowe wrote:
There is no real need (or benefit) from having the database on a
journalled filesystem - the journalling is only trying to give similar
sorts of guarantees to what the fsync in PostgreSQL is doing.
Is this
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
But it should be okay to set the filesystem to journal only its own
metadata. There's no need for it to journal file contents.
Can you set ext2 to journal metadata? I didn't know it could do that.
No, ext2 has
hello,
I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M RAM),
can anyone give me some advice?
huang yaqin wrote:
hello,
I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M
RAM), can anyone give
huang yaqin [EMAIL PROTECTED] writes:
I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M
RAM), can
huang yaqin wrote:
hello,
I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
This is most likely a dual processor Xeon machine with HT, because the
x335 is limited to two physical
hello
Thanks, you are right.
I use postmaster -o -F to start my PGand performance improved greatly.
Best regards,
huang yaqin
huang yaqin [EMAIL PROTECTED] writes:
I have some question when I use postgresql 7.4.1 on redhat adv server
18 matches
Mail list logo