autovacuum question
Hello,
I'not using autovacuum as the largest part of my tables are filled with
COPY FROM, not modified afterward and dropped when obsolete.
Other tables are regularily vacuumed from an application driven job
that knows which tables were modified recently.
(It also vacuums th
Jaume Sabater writes:
> On Fri, Jan 30, 2009 at 2:22 AM, Tom Lane wrote:
>> We probably should add a caution about this to the manual's discussion
>> of how to write archiving scripts.
> I presume you mean the copy/transfer process did not do its job
> correctly, Tom. Therefore, I would advise u
Zitat von Suresh Borse :
Dear All,
How to migrate existing database which in Oracle to postgres?
Please provide me the solution/limitation for triggers , procedure ,
packages & views while migrating.
Thanks & Regards,
Suresh Borse
(DBA)
Not long ago someone posted the following link
htt
Hi, you can see this link:
http://www.enterprisedb.com/products/postgres_plus_as/compatibility.do
Or case studio
http://it.toolbox.com/blogs/oracle-guide/sony-replaces-oracle-with-enterprisedb-8365
Jared López L.
DBA PostgreSQL
Santa Cruz - Bolivia
2009/1/30 Suresh Borse
> Dear All,
>
> How
Dear All,
How to migrate existing database which in Oracle to postgres?
Please provide me the solution/limitation for triggers , procedure ,
packages & views while migrating.
Thanks & Regards,
Suresh Borse
(DBA)
On Freitag 30 Januar 2009 Tom Lane wrote:
> The -Fc (and -Ft) formats are only designed to hold the contents of a
> single database; and pg_restore only knows how to restore into a
> single database.
>
> If you feel like fixing that, step right up.
Sorry, didn't want to step on toes here. I know t
On Fri, Jan 30, 2009 at 2:22 AM, Tom Lane wrote:
> We probably should add a caution about this to the manual's discussion
> of how to write archiving scripts.
I presume you mean the copy/transfer process did not do its job
correctly, Tom. Therefore, I would advise using a script that compares
th
