Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f351rg834770 for ; Wed, 4 Apr 2001 21:53:42 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f351rUw14401; Wed, 4 Apr 2001 21:53:31 -0400 (EDT) To: edipoelder@ig.com.br cc: pgsql-sql@postgresql.org Subject: Re: Memory and performance In-reply-to: <200104041715.f34HF8858323@postgresql.org> References: <200104041715.f34HF8858323@postgresql.org> Comments: In-reply-to edipoelder@ig.com.br message dated "Wed, 04 Apr 2001 14:15:05 -0300" Date: Wed, 04 Apr 2001 21:53:30 -0400 Message-ID: <14398.986435610@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/70 X-Sequence-Number: 2410 edipoelder@ig.com.br writes: > I have noted that Postgresql don't make a good memory handle. I have > made the tables/procedure (in attached file) and run it as "select bench(10, > 5000)". This will give a 50000 records inserts (5 x 10000). (well, I run it > on a P200+64MB of RAM, under Linux, and Postgres 7.0.2. In a more powerfull > machine, you can try other values). > I get as result, the following times: > id | objname | benchtime > ----+---------+----------- > 1 | group 1 | 00:00:32 > 2 | group 2 | 00:00:47 > 3 | group 3 | 00:01:13 > 4 | group 4 | 00:01:41 > 5 | group 5 | 00:02:08 > (5 rows) This is an inefficiency in handling of foreign-key triggers. It's fixed for 7.1 --- in current sources I get id | objname | benchtime ----+----------+----------- 1 | group 1 | 00:00:03 2 | group 2 | 00:00:03 3 | group 3 | 00:00:03 4 | group 4 | 00:00:03 5 | group 5 | 00:00:03 6 | group 6 | 00:00:03 7 | group 7 | 00:00:03 8 | group 8 | 00:00:03 9 | group 9 | 00:00:03 10 | group 10 | 00:00:03 (10 rows) regards, tom lane