Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id CB6AB9F9F0E
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  3 Dec 2006 07:11:43 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 63494-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  3 Dec 2006 07:11:37 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mail.totaltelecom.ro (mail.totaltelecom.ro [89.36.0.12])
	by postgresql.org (Postfix) with ESMTP id 507539F9EED
	for <pgsql-performance@postgresql.org>;
	Sun,  3 Dec 2006 07:11:37 -0400 (AST)
Received: from mail.totaltelecom.ro (localhost [127.0.0.1])
	by mail.totaltelecom.ro (Postfix) with ESMTP id F3B5534BE9A;
	Sun,  3 Dec 2006 13:11:35 +0200 (EET)
Received: by mail.totaltelecom.ro (Postfix, from userid 99)
	id E67D234BEA8; Sun,  3 Dec 2006 13:11:35 +0200 (EET)
Received: from alex (unknown [86.107.100.199])
	by mail.totaltelecom.ro (Postfix) with ESMTP id A079434BE9A;
	Sun,  3 Dec 2006 13:11:35 +0200 (EET)
Message-ID: <001301c716cb$c8346e80$c7646b56@alex>
From: "Alexandru Coseru" <alexandru.coseru@totaltelecom.ro>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-performance@postgresql.org>
References: <030b01c71651$984577c0$8300a8c0@tridecap.com>
	<01ea01c71653$438254e0$3cb16956@alex>
	<4571F856.7090808@enterprisedb.com>
	<022c01c7165f$17f49e80$3cb16956@alex>
	<4571FFA6.6070804@enterprisedb.com>
	<024601c71675$81277560$3cb16956@alex>
	<12526.1165118712@sss.pgh.pa.us>
Subject: Re: Regex performance issue 
Date: Sun, 3 Dec 2006 13:11:29 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-Virus-Scanned: ClamAV using ClamSMTP
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/27
X-Sequence-Number: 22083

Hello..

I presumed CPU intensive  because:
    1) I have no hdd lights turn on during a series of queries (about 50 of 
them)
    2) vmstat doesn't give me blocks in and just a couple of blocks out.
    3) top  reports between 95 and 100 user cpu    .    sometimes ,i can see 
some  hi and si work  (max of 2%).


I'm pretty sure that the whole table is in cache..
The table size is about 50 Megs  , and I have 1 Gb of RAM..
I have no other RAM eating procesess.

Could it be related to  CPU <-> RAM speed ?

Regards
    Alex

----- Original Message ----- 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Alexandru Coseru" <alexandru.coseru@totaltelecom.ro>
Cc: "Heikki Linnakangas" <heikki@enterprisedb.com>; 
<pgsql-performance@postgresql.org>
Sent: Sunday, December 03, 2006 6:05 AM
Subject: Re: [PERFORM] Regex performance issue


> "Alexandru Coseru" <alexandru.coseru@totaltelecom.ro> writes:
>> Anyway , anybody has a clue why this regex is that CPU intensive ?
>
> The EXPLAIN result you posted offers *no* evidence that the regexp is
> CPU intensive.  All you know is that it took 850+ msec to fetch 5200
> rows from disk and apply the regexp filter to them.  There's no evidence
> here that that was CPU time and not I/O time.
>
> regards, tom lane
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.15.4/563 - Release Date: 12/2/2006
>
>