Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Performance while loading data and indexing

From: Justin Clift <justin(at)postgresql(dot)org>
To: shridhar_daithankar(at)persistent(dot)co(dot)in
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] Performance while loading data and indexing
Date: 2002-09-26 09:49:53
Message-ID: 3D92D841.3E02B2A8@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-performance
Shridhar Daithankar wrote:
<snip>
> > > fsync=true (Sad but true. Left untouched.. Will that make a difference on
> > > SCSI?)
> >
> > Definitely.  Have directly measured a ~ 2x tps throughput increase on
> > FreeBSD when leaving fsync off whilst performance measuring stuff
> > recently (PG 7.2.2).  Like anything it'll depend on workload, phase of
> > moon, etc, but it's a decent indicator.
> 
> I didn't know even that matters with SCSI..Will check out..

Cool.  When testing it had FreeBSD 4.6.2 installed on one drive along
with the PostgreSQL 7.2.2 binaries, it had the data on a second drive
(mounted as /pgdata), and it had the pg_xlog directory mounted on a
third drive.  Swap had it's own drive as well.

Everything is UltraSCSI, etc.  Haven't yet tested for a performance
difference through moving the indexes to another drive after creation
though.  That apparently has the potential to help as well.

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

In response to

pgsql-performance by date

Next:From: Justin CliftDate: 2002-09-26 09:56:34
Subject: Re: [HACKERS] Performance while loading data and indexing
Previous:From: Richard HuxtonDate: 2002-09-26 09:48:06
Subject: Re: Performance while loading data and indexing

pgsql-hackers by date

Next:From: Mario WeilguniDate: 2002-09-26 09:50:08
Subject: Re: Performance while loading data and indexing
Previous:From: Richard HuxtonDate: 2002-09-26 09:48:06
Subject: Re: Performance while loading data and indexing

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2002-09-26 09:54:48
Subject: Re: [HACKERS] Performance while loading data and indexing
Previous:From: Richard HuxtonDate: 2002-09-26 09:48:06
Subject: Re: Performance while loading data and indexing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group