| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com> |
| Cc: | "Rodrigo De Leon" <rdeleonp(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Table size growing for no reason |
| Date: | 2006-07-14 06:07:00 |
| Message-ID: | 9080.1152857220@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Benjamin Krajmalnik" <kraj(at)illumen(dot)com> writes:
> I was playing around trying to tweak the performance of the database.
> As part of the process, I increased the number of WAL buffers to 32 and
> the checkpoint segments to 16.
> That appears to have been the culprit! I set them back at the same
> levels I was previously using (16 and 4, respectively), and now the
> table is no longer misbehaving.
Um ... changing those parameters should have affected the contents of
$PGDATA/pg_xlog, but not of the table per se. What were you measuring
exactly?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kitaeda | 2006-07-14 06:36:30 | *** How can I install two postgresqls in the same machine? ***** |
| Previous Message | Curtis Preston | 2006-07-14 04:35:45 | Want to tech review PostgreSQL backup chapter? |