I will get that and post it.
NEW NEWS... turning off "enable_seqscan" made the query run in about .25
seconds!!!
Now we're re-evaluating effective_cache_size
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 12, 2007 5:43 PM
To: Porell, C
ows=1
loops=4918)
Index Cond:
(c.recordnumber = "outer".recordnumber)
-> Hash (cost=6.27..6.27 rows=127
width=4) (actual time=0.393..0.393 rows=127 loops=1)
Hi All,
I have recently migrated a Postgres database from 7.4 running on gentoo to
8.1 running on SLES 10. I migrated the data using pg_dump and then running
the SQL in psql. The old server was a dual AMD opteron 2.6 GHz machine with
a RAID 5 array and 4GB memory. The new machine is a dual dual
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 4:41 PM
To: Porell, Chris
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] log shipping/DB recovery with PostgreSQL 7.4
Porell, Chris wrote:
> I am trying to bring up a disaster recovery database using a cold-copy of
&g
I am trying to bring up a disaster recovery database using a cold-copy of
the datafiles on a different machine. I've got all WAL files since this
copy was made. Is it possible to make a 7.4 DB apply the WALs to the DB
when I bring it up?
Thanks!
Chris
-
third point, I absolutely agree.
I will continue to look through the archives as well.
Thank you!!
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 3:02 PM
To: Porell, Chris
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENE
Hi everyone,
newbie here...
I have a need to get paid support services for a new postgres implemetation.
I've looked at some of the companies listed at www.postgresql.org that offer
professional services.
I've perused some of the mailing list archived, but I can't seem to find the
info I need.
