IL PROTECTED]
Cc: PGSQL Admin
Subject: Re: [ADMIN] Why this Query Plan is different
"Thilina Gunasekara" <[EMAIL PROTECTED]> writes:
> I have two PostgreSQL Database Servers running on Gentoo which versions
are
> PostgreSQL 7.4.5 (Box A) and PostgreSQL 7.3.9 (Box B)
>
::text)
-> Seq Scan on properties (cost=0.00..2137.58 rows=40158
width=13)
-> Hash (cost=179.54..179.54 rows=7654 width=7)
-> Seq Scan on airport_codes (cost=0.00..179.54 rows=7654
width=7)
Thilina Gunasekara
Database Administrator
--
Assuming you're using Unix Box
1. Dump your database DB_X
pg_dump -v -U postgresUsername DB_X | gzip -f - > DB_X.gz
2.Create database DB_Y
psql -U postgresUsername template1
CREATE DATABASE DB_Y
\q
3. zcat DB_X.gz | psql -U postgresUsername -f - DB_Y
Thilina
-Original Message-
From: [E
