Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit7bce3e9

Browse files
committed
Remove mutex mention. Fixed now.
1 parent182722f commit7bce3e9

File tree

1 file changed

+10
-68
lines changed

1 file changed

+10
-68
lines changed

‎doc/TODO.detail/performance

Lines changed: 10 additions & 68 deletions
Original file line numberDiff line numberDiff line change
@@ -345,7 +345,7 @@ From owner-pgsql-hackers@hub.org Tue Oct 19 10:31:10 1999
345345
Received: from renoir.op.net (root@renoir.op.net [209.152.193.4])
346346
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id KAA29087
347347
for <maillist@candle.pha.pa.us>; Tue, 19 Oct 1999 10:31:08 -0400 (EDT)
348-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.7 $) with ESMTP id KAA27535 for <maillist@candle.pha.pa.us>; Tue, 19 Oct 1999 10:19:47 -0400 (EDT)
348+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.8 $) with ESMTP id KAA27535 for <maillist@candle.pha.pa.us>; Tue, 19 Oct 1999 10:19:47 -0400 (EDT)
349349
Received: from localhost (majordom@localhost)
350350
by hub.org (8.9.3/8.9.3) with SMTP id KAA30328;
351351
Tue, 19 Oct 1999 10:12:10 -0400 (EDT)
@@ -371,7 +371,7 @@ Date: Tue, 19 Oct 1999 10:09:15 -0400
371371
Message-ID: <9036.940342155@sss.pgh.pa.us>
372372
From: Tom Lane <tgl@sss.pgh.pa.us>
373373
Sender: owner-pgsql-hackers@postgreSQL.org
374-
Status:OR
374+
Status:RO
375375

376376
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
377377
> 1. shared cache holds committed system tuples.
@@ -454,7 +454,7 @@ From owner-pgsql-hackers@hub.org Tue Oct 19 21:25:30 1999
454454
Received: from renoir.op.net (root@renoir.op.net [209.152.193.4])
455455
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id VAA28130
456456
for <maillist@candle.pha.pa.us>; Tue, 19 Oct 1999 21:25:26 -0400 (EDT)
457-
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.7 $) with ESMTP id VAA10512 for <maillist@candle.pha.pa.us>; Tue, 19 Oct 1999 21:15:28 -0400 (EDT)
457+
Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.8 $) with ESMTP id VAA10512 for <maillist@candle.pha.pa.us>; Tue, 19 Oct 1999 21:15:28 -0400 (EDT)
458458
Received: from localhost (majordom@localhost)
459459
by hub.org (8.9.3/8.9.3) with SMTP id VAA50745;
460460
Tue, 19 Oct 1999 21:07:23 -0400 (EDT)
@@ -487,7 +487,7 @@ X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
487487
X-Mimeole: Produced By Microsoft MimeOLE V4.72.2106.4
488488
Importance: Normal
489489
Sender: owner-pgsql-hackers@postgreSQL.org
490-
Status:ORr
490+
Status:RO
491491

492492
> -----Original Message-----
493493
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
@@ -573,7 +573,7 @@ From: Tom Lane <tgl@sss.pgh.pa.us>
573573
X-Mailing-List: pgsql-hackers@postgresql.org
574574
Precedence: bulk
575575
Sender: pgsql-hackers-owner@hub.org
576-
Status:ORr
576+
Status:RO
577577

578578
Those of you with long memories may recall a benchmark that Edmund Mergl
579579
drew our attention to back in May '99. That test showed extremely slow
@@ -648,7 +648,7 @@ Content-Type: text/plain; charset=us-ascii
648648
Content-Disposition: inline
649649
User-Agent: Mutt/1.2i
650650
In-Reply-To: <200101191703.MAA25873@candle.pha.pa.us>; from pgman@candle.pha.pa.us on Fri, Jan 19, 2001 at 12:03:58PM -0500
651-
Status:OR
651+
Status:RO
652652

653653
On Fri, Jan 19, 2001 at 12:03:58PM -0500, Bruce Momjian wrote:
654654
>
@@ -722,7 +722,7 @@ Content-Type: text/plain;
722722
charset="iso-8859-1"
723723
Precedence: bulk
724724
Sender: pgsql-hackers-owner@postgresql.org
725-
Status:OR
725+
Status:RO
726726

727727
> > Tom, did we ever test this? I think we did and found that
728728
> > it was the same or worse, right?
@@ -760,7 +760,7 @@ Subject: Re: 7.2 items
760760
References: <200106071503.f57F32n03924@candle.pha.pa.us>
761761
Content-Type: text/plain; charset=us-ascii
762762
Content-Transfer-Encoding: 7bit
763-
Status:OR
763+
Status:RO
764764

765765
Bruce Momjian wrote:
766766

@@ -829,7 +829,7 @@ X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211
829829
MIME-Version: 1.0
830830
Content-Type: text/plain; charset="us-ascii"
831831
Content-Transfer-Encoding: 7bit
832-
Status:OR
832+
Status:RO
833833

834834
And in addition,
835835

@@ -930,7 +930,7 @@ In-Reply-To: <3B1FC9CB.57C72AD6@mohawksoft.com>
930930
Message-ID: <Pine.GSO.4.33.0106072234120.6015-100000@ra.sai.msu.su>
931931
MIME-Version: 1.0
932932
Content-Type: TEXT/PLAIN; charset=US-ASCII
933-
Status:OR
933+
Status:RO
934934

935935
I think it's possible to implement bitmap indexes with a little
936936
effort using GiST. at least I know one implementation
@@ -1002,61 +1002,3 @@ Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
10021002
phone: +007(095)939-16-83, +007(095)939-23-83
10031003

10041004

1005-
From pgsql-hackers-owner+M11649@postgresql.org Wed Aug 1 15:22:46 2001
1006-
Return-path: <pgsql-hackers-owner+M11649@postgresql.org>
1007-
Received: from postgresql.org (webmail.postgresql.org [216.126.85.28])
1008-
by candle.pha.pa.us (8.10.1/8.10.1) with ESMTP id f71JMjN09768
1009-
for <pgman@candle.pha.pa.us>; Wed, 1 Aug 2001 15:22:45 -0400 (EDT)
1010-
Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
1011-
by postgresql.org (8.11.3/8.11.1) with SMTP id f71JMUf62338;
1012-
Wed, 1 Aug 2001 15:22:30 -0400 (EDT)
1013-
(envelope-from pgsql-hackers-owner+M11649@postgresql.org)
1014-
Received: from sectorbase2.sectorbase.com (sectorbase2.sectorbase.com [63.88.121.62] (may be forged))
1015-
by postgresql.org (8.11.3/8.11.1) with SMTP id f71J4df57086
1016-
for <pgsql-hackers@postgresql.org>; Wed, 1 Aug 2001 15:04:40 -0400 (EDT)
1017-
(envelope-from vmikheev@SECTORBASE.COM)
1018-
Received: by sectorbase2.sectorbase.com with Internet Mail Service (5.5.2653.19)
1019-
id <PG1LSSPZ>; Wed, 1 Aug 2001 12:04:31 -0700
1020-
Message-ID: <3705826352029646A3E91C53F7189E32016705@sectorbase2.sectorbase.com>
1021-
From: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
1022-
To: "'pgsql-hackers@postgresql.org'" <pgsql-hackers@postgresql.org>
1023-
Subject: [HACKERS] Using POSIX mutex-es
1024-
Date: Wed, 1 Aug 2001 12:04:24 -0700
1025-
MIME-Version: 1.0
1026-
X-Mailer: Internet Mail Service (5.5.2653.19)
1027-
Content-Type: text/plain;
1028-
charset="koi8-r"
1029-
Precedence: bulk
1030-
Sender: pgsql-hackers-owner@postgresql.org
1031-
Status: OR
1032-
1033-
1. Just changed
1034-
TAS(lock) to pthread_mutex_trylock(lock)
1035-
S_LOCK(lock) to pthread_mutex_lock(lock)
1036-
S_UNLOCK(lock) to pthread_mutex_unlock(lock)
1037-
(and S_INIT_LOCK to share mutex-es between processes).
1038-
1039-
2. pgbench was initialized with scale 10.
1040-
SUN WS 10 (512Mb), Solaris 2.6 (I'm unable to test on E4500 -:()
1041-
-B 16384, wal_files 8, wal_buffers 256,
1042-
checkpoint_segments 64, checkpoint_timeout 3600
1043-
50 clients x 100 transactions
1044-
(after initialization DB dir was saved and before each test
1045-
copyed back and vacuum-ed).
1046-
1047-
3. No difference.
1048-
Mutex version maybe 0.5-1 % faster (eg: 37.264238 tps vs 37.083339 tps).
1049-
1050-
So - no gain, but no performance loss "from using pthread library"
1051-
(I've also run tests with 1 client), at least on Solaris.
1052-
1053-
And so - looks like we can use POSIX mutex-es and conditional variables
1054-
(not semaphores; man pthread_cond_wait) and should implement light lmgr,
1055-
probably with priority locking.
1056-
1057-
Vadim
1058-
1059-
---------------------------(end of broadcast)---------------------------
1060-
TIP 2: you can get off all lists at once with the unregister command
1061-
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
1062-

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp