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
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
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 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
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
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
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
