At 05:51 PM 2/3/03 -0500, Tom Lane wrote:
>wade <[EMAIL PROTECTED]> writes:
>> Here is the profile information.  I included a log of the session that
>> generated it at the top of the gprof  output.  If there is any other info I
>> can help you with, please let me know.
>A four-second test isn't long enough to gather any statistically
>meaningful profile info.  On most machines, gprof samples 100 times per
>second, so realistically you need a minute or two of runtime to have
>trustworthy numbers.
>Please replicate the rows in the table by a factor of ten or twenty or
>so and try again.
>                       regards, tom lane
OK, here goes again.
I have tried a different table, this one with 27444 rows.
In this case, the query with the regex of the form "row ~* 'regex'"
runs in 1.113 seconds and the other runs in 600.
The session idled for a while after the query completed if that makes a
Queries and explain output are included at the top of the gprof output.
  -Wade Klaver

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to