| From: | Alvaro Herrera <alvherre(at)commandprompt(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 00:20:23 |
| Message-ID: | 20091219002023.GW4055@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alex - wrote:
>
> Tom, I am logging these stats now, but i am having a similar issue. both jobs in the morning and after noon insert about 400k records (200k each)
> In the morning that job takes 450secIn the afternoon only 150; No select, simple parsing a file and insert the records
> These two tables don't grow as at night a cleanup job removes about the same amount of historical data (older about 40 days).
> Its kind of the same behavior and i don't really see where the swapping fits in.
Are you running vacuum of some sort on this table regularly?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex - | 2009-12-19 00:40:07 | Re: PL/Perl Performance Problems |
| Previous Message | Chris Ernst | 2009-12-19 00:07:20 | Re: Extracting SQL from logs in a usable format |