pgsql: Add ORDER BY to vacummdb so databases are scaned in the same

Started by Bruce Momjianabout 19 years ago3 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Log Message:
-----------
Add ORDER BY to vacummdb so databases are scaned in the same order as
pg_dumpall.

Modified Files:
--------------
pgsql/src/bin/scripts:
vacuumdb.c (r1.15 -> r1.16)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/scripts/vacuumdb.c.diff?r1=1.15&r2=1.16)

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#1)
Re: [COMMITTERS] pgsql: Add ORDER BY to vacummdb so databases are scaned in the same

momjian@postgresql.org (Bruce Momjian) writes:

Log Message:
-----------
Add ORDER BY to vacummdb so databases are scaned in the same order as
pg_dumpall.

If we're gonna do that (which I have no objection to), shouldn't
clusterdb and reindexdb do the same?

regards, tom lane

#3Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#2)
Re: [COMMITTERS] pgsql: Add ORDER BY to vacummdb so databases are scaned in the same

Tom Lane wrote:

momjian@postgresql.org (Bruce Momjian) writes:

Log Message:
-----------
Add ORDER BY to vacummdb so databases are scaned in the same order as
pg_dumpall.

If we're gonna do that (which I have no objection to), shouldn't
clusterdb and reindexdb do the same?

Done, thanks.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +