Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Table size growing for no reason
- 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: Fri, 14 Jul 2006 02:07:00 -0400
"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
- References:
- Re: Table size growing for no reason
- From: Benjamin Krajmalnik
- Re: Table size growing for no reason
- Prev by Date: Want to tech review PostgreSQL backup chapter?
- Next by Date: *** How can I install two postgresqls in the same machine? *****
- Previous by thread: Re: Table size growing for no reason
- Next by thread: Want to tech review PostgreSQL backup chapter?
- Indexes: