pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
auto vacuuming
4+ messages / 2 participants
[nested] [flat]

* auto vacuuming
@ 2007-04-05 17:42  Sumeet <asumeet@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Sumeet @ 2007-04-05 17:42 UTC (permalink / raw)
  To: pgsql-sql

Hi all is there a way i can find if the pg_autovacuum module is installed on
my server??
The postgres version im using is 8.1.4
I tried searching the contrib module and dint see the pg_autovacuum
directory there
I checked m source

Thanks,
Sumeet

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: auto vacuuming
@ 2007-04-05 17:51  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Sumeet <asumeet@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Alvaro Herrera @ 2007-04-05 17:51 UTC (permalink / raw)
  To: Sumeet <asumeet@gmail.com>; +Cc: pgsql-sql

Sumeet escribió:
> Hi all is there a way i can find if the pg_autovacuum module is installed on
> my server??
> The postgres version im using is 8.1.4
> I tried searching the contrib module and dint see the pg_autovacuum
> directory there

pg_autovacuum no longer exists.  Autovacuum is now integrated into the
core.  So the way to find if it's installed is "yes".

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: auto vacuuming
@ 2007-04-05 18:00  Sumeet <asumeet@gmail.com>
  parent: Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Sumeet @ 2007-04-05 18:00 UTC (permalink / raw)
  To: Sumeet <asumeet@gmail.com>; pgsql-sql

Then do i need to still provide the auto vacumming options in the
postgres.conf file or these options are automatically taken care of.

Thanks,
Sumeet.

On 4/5/07, Alvaro Herrera <alvherre@commandprompt.com> wrote:
>
> Sumeet escribió:
> > Hi all is there a way i can find if the pg_autovacuum module is
> installed on
> > my server??
> > The postgres version im using is 8.1.4
> > I tried searching the contrib module and dint see the pg_autovacuum
> > directory there
>
> pg_autovacuum no longer exists.  Autovacuum is now integrated into the
> core.  So the way to find if it's installed is "yes".
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>



-- 
Thanks,
Sumeet Ambre
Master of Information Science Candidate,
Indiana University.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: auto vacuuming
@ 2007-04-05 18:19  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Sumeet <asumeet@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Alvaro Herrera @ 2007-04-05 18:19 UTC (permalink / raw)
  To: Sumeet <asumeet@gmail.com>; +Cc: pgsql-sql

Sumeet escribió:
> Then do i need to still provide the auto vacumming options in the
> postgres.conf file or these options are automatically taken care of.

You have to enable the autovacuum setting in postgresql.conf.  It is not
enabled by default.


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-04-05 18:19 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-05 17:42 auto vacuuming Sumeet <asumeet@gmail.com>
2007-04-05 17:51 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-04-05 18:00   ` Sumeet <asumeet@gmail.com>
2007-04-05 18:19     ` Alvaro Herrera <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox