Re: PL/Perl Performance Problems

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alex - <aintokyo(at)hotmail(dot)com>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-general(at)postgresql(dot)org
Subject: Re: PL/Perl Performance Problems
Date: 2009-12-19 06:00:16
Message-ID: dcc563d10912182200y966f61eq692bb7374301be2f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Note that you seem to have a lot more IO wait in the first run than in
the second, which means that the task is hitting the disks more in the
first run than in the second one. Once IO wait starts to climb,
performance starts to dive, generally.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Postgres User 2009-12-19 06:05:19 Re: Selecting from table into an array var
Previous Message Merlin Moncure 2009-12-19 05:53:00 Re: Selecting from table into an array var