| From: | "Eugene M(dot) Zheganin" <emz(at)norma(dot)perm(dot)ru> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Full vacuuming of BIG tables takes too long |
| Date: | 2003-05-26 07:48:51 |
| Message-ID: | 1841310057656.20030526134851@norma.perm.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello Robert,
Thursday, May 22, 2003, 8:01:58 PM, you wrote:
RT> On Thu, 2003-05-22 at 08:37, Eugene M. Zheganin wrote:
RT> My first suggestion would be to check your free space map settings in
RT> the postgresql.conf and make sure they are set high enough.
They are set to defaults.
RT> Setting
RT> them to low can cause Vacuum Full to take longer than necessary.
I read " Server Run-time Environment" from Postgresql docs, but I
don't understand how I can calculate optimum values ? (where I can
read about it in pgsql docs ?)
Can you give me any further explanations 8) ?
--
Best regards,
Eugene mailto:emz(at)norma(dot)perm(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ewdani | 2003-05-26 08:31:25 | Inquiry From Form [pgsql] |
| Previous Message | Tom Lane | 2003-05-26 05:34:07 | Re: vacuum info - crash |