Hi everybody,
are there how define autovacuum to ON and define the period time (for
example, 00h - 06h) that it's can run?
tks
Fábio Henrique Gibon
Comex System Consultoria
On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote:
> Hi everybody,
> are there how define autovacuum to ON and define the period
> time (for example, 00h - 06h) that it's can run?
>
No. You would need to write your own job manager (or use one of the many
that already ex
I want perform VACUUM on specific tables. This tables are result of query in my
database (select tablename from mytablesvacuum). I tryed use a cursor
on function, but i receive message that vacuun can't run in function.
Any idea to do this?
tks
Fábio Henrique Gibon
Comex System Consultoria
Excerpts from Fábio Gibon - Comex System's message of mar jul 20 12:20:36 -0400
2010:
> Hi everybody,
> are there how define autovacuum to ON and define the period time (for
> example, 00h - 06h) that it's can run?
You could have a script that toggles the value in postgresql.conf and do
Perfect!!!
I'm starting with PostgreSQL (my knowledge is Oracle). Can you explain more
about autovacuum? for example...
1 - on windows SO, autovacuum start works (postgres.exe as
autovacuum_max_workers) ?
2 - what moment autovacuum check se necessary run or not? (when ocurred dml
statament
Excerpts from Fábio Gibon - Comex System's message of mar jul 20 16:13:39 -0400
2010:
> Perfect!!!
>
> I'm starting with PostgreSQL (my knowledge is Oracle). Can you explain more
> about autovacuum? for example...
> 1 - on windows SO, autovacuum start works (postgres.exe as
> autovacuum_max_wor
On Monday 19 July 2010 19:15:32 Kevin Grittner wrote:
> Burgholzer, Robert (DEQ)"
>
> wrote:
> > This is really interesting. Is there a way to set the locale on
> > the fly for a sort? Having looked at the docs, it appears as if
> > the initDB step is the only opportunity to do so.
>
> Startin
