Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/Perl Performance Problems - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PL/Perl Performance Problems
Date
Msg-id dcc563d10912182200y966f61eq692bb7374301be2f@mail.gmail.com
Whole thread Raw
In response to Re: PL/Perl Performance Problems  (Alex - <aintokyo@hotmail.com>)
Responses Re: PL/Perl Performance Problems  (Alex - <aintokyo@hotmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Selecting from table into an array var
Next
From: Postgres User
Date:
Subject: Re: Selecting from table into an array var