From: | Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> |
---|---|
To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
Cc: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Size for vacuum_mem |
Date: | 2002-12-05 19:00:03 |
Message-ID: | 3DEFA233.6050403@intransa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can someone please explain the relatiionship between operation of a
vacuum-ing job
and vacuum_mem setting in non-shared memfory configuration.
Ie from a capacity planning point of view, how is vacuum_mem's size is
related to this
operation. The current 8k default seems so low...
Thanks
Shridhar Daithankar wrote:
>On 4 Dec 2002 at 19:38, Neil Conway wrote:
>
>
>
>>>Currently a vacuum full takes 3+ hours and very soon the amount of data
>>>will increase.
>>>
>>>
>>Do you need to use VACUUM FULL?
>>
>>
>
>Let me elaborate this statement.
>
>1) You need vacuum full only to recover space from deleted tuples. Unless the
>database has undergone major deletion somewhere 'vacuum full' might be a cannon
>to kill an ant.
>
>2) You should consider vacuuming tablewise. Vacuum is useful only for those
>tables which change at a faster rate. A lookup or archive table might not need
>vacuum. Just vacuum the tables which are heavily updated/deleted/inserted. And
>by heavily, I mean heavily in terms of tuples. Inserting a single 200MB BLOB
>and vacuuming the table might not yield any performance improvement..
>
> HTH
>
>Bye
> Shridhar
>
>--
>blithwapping: Using anything BUT a hammer to hammer a nail into the wall, such
>as shoes, lamp bases, doorstops, etc. -- "Sniglets", Rich Hall & Friends
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-05 19:17:08 | Re: [GENERAL] PostgreSQL Global Development Group Announces |
Previous Message | Bruce Momjian | 2002-12-05 18:54:46 | Re: [GENERAL] PostgreSQL Global Development Group Announces |