pre-beta is slow 
Author Message
 pre-beta is slow
recently  I  have downloaded a pre-beta postgresql,  I found  insert and update speed is slower then 7.0.3,
even I turn of sync flag,  it is still slow than 7.0, why? how can I make it faster?

Regards,
XuYifeng



Mon, 26 May 2003 17:07:16 GMT
 pre-beta is slow

Quote:
> recently  I  have downloaded a pre-beta postgresql,  I found  
> insert and update speed is slower then 7.0.3,
> even I turn of sync flag,  it is still slow than 7.0, why?
> how can I make it faster?

Try to compare 7.0.3 & 7.1beta in multi-user environment.

Vadim



Tue, 27 May 2003 04:35:24 GMT
 pre-beta is slow

Quote:

> > recently  I  have downloaded a pre-beta postgresql,  I found
> > insert and update speed is slower then 7.0.3,
> > even I turn of sync flag,  it is still slow than 7.0, why?

How much slower do you see it to be ?

Quote:
> > how can I make it faster?

> Try to compare 7.0.3 & 7.1beta in multi-user environment.

As I understand it you claim it to be faster in multi-user environment ?

Could you give some brief technical background why is it so
and why must it make single-user slower ?

---------------
Hannu



Tue, 27 May 2003 22:37:45 GMT
 pre-beta is slow

Quote:

> Because of commit in 7.1 does fsync, with ot without -F
> (we can discuss and change this), but in multi-user env
> a number of commits can be made with single fsync.

I was planning to ask why you disabled the -F switch.  Seems to me that
people who trusted their OS+hardware before would still want to do so
in 7.1, and so it still makes sense to be able to suppress the fsync
calls.

                        regards, tom lane



Wed, 28 May 2003 03:20:02 GMT
 pre-beta is slow

Quote:
> > Because of commit in 7.1 does fsync, with ot without -F
> > (we can discuss and change this), but in multi-user env
> > a number of commits can be made with single fsync.

> I was planning to ask why you disabled the -F switch. Seems
> to me that people who trusted their OS+hardware before would
> still want to do so in 7.1, and so it still makes sense to be
> able to suppress the fsync calls.

I just didn't care about -F functionality, sorry.
I agreed that we should resurrect it.

Vadim



Wed, 28 May 2003 03:31:21 GMT
 pre-beta is slow

Quote:
> > > Try to compare 7.0.3 & 7.1beta in multi-user environment.

> > As I understand it you claim it to be faster in multi-user
> > environment ?

> > Could you give some brief technical background why is it so
> > and why must it make single-user slower ?

> Because of commit in 7.1 does fsync, with ot without -F
> (we can discuss and change this), but in multi-user env
> a number of commits can be made with single fsync.
> Seems I've described this before?

Ops, I forgot to answer question "why in single-user env 7.1 is
slower than 7.0.3?". I assumed that 7.1 was compared with 7.0.3
*with -F*, which probably is not correct, I don't know.
Well, the next test shows that 7.1 is faster in single-user env
than 7.0.3 *without -F*:

table (i int, t text); 1000 INSERTs (in separate transactions),
sizeof(t) 1 .. 256:

7.0.3: 42 sec -> 24 tps
7.1  : 24 sec -> 42 tps

Vadim



Wed, 28 May 2003 03:42:06 GMT
 pre-beta is slow

Quote:
> > I just didn't care about -F functionality, sorry.
> > I agreed that we should resurrect it.

> OK.  Do you want to work on that, or shall I?

In near future I'll be busy doing CRC + "physical log"
things...

Vadim



Wed, 28 May 2003 04:49:22 GMT
 pre-beta is slow

Quote:

> I just didn't care about -F functionality, sorry.
> I agreed that we should resurrect it.

OK.  Do you want to work on that, or shall I?

                        regards, tom lane



Wed, 28 May 2003 05:07:20 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. PG 7.1 pre-beta bug ...

2. Pre-release Oracle Beta Testers

3. PG 7.1 pre-beta bug ...

4. Why am I so Slow

5. VFP-SLOW Beta Testers Non Disclosure Agreement

6. Slow, slow, slow DDEs

7. Insert into SQL Server slow, slow, slow...

8. Unique Index gets slower and slower and slower for inserts

9. error ORA-01855: AM/A.M. or PM/P.M. required

10. DB Getting Slower and Slower and Slower....

11. Why does my BCP Load run slower, and slower, and slower

12. Use of @am, Am I dumb?


 
Powered by phpBB® Forum Software