[PERFORM] loading same instance of dump to two different servers simultaneously?

me Thanks for any advice. Susan Russo ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'

SORRY - these are the commands (i.e. pgserver-A and pgserver-B) == Hi - I'm wondering if anyone has had success doing a simultaneous load of one Pg dump to two different servers? The load command is actually run from two different workstations, but reading the same pgdump-file. We use th

Re: [PERFORM] does VACUUM ANALYZE complete with this error?

ests=AWL,BAYES_50,SPF_HELO_PASS autolearn=unavailable version=3.1.4 X-Spam-Level: To: Susan Russo <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED], pgsql-performance@postgresql.org Subject: Re: [PERFORM] does VACUUM ANALYZE complete with this error? Comments: In-reply-to Susan Russo <

Re: [PERFORM] does VACUUM ANALYZE complete with this error?

[EMAIL PROTECTED] Wed May 23 10:01:07 2007 X-Spam-Checker-Version: SpamAssassin 3.1.4 (2006-07-25) on borise.harvard.edu X-Spam-Status: No, score=-0.2 required=3.0 tests=AWL,BAYES_40,SPF_HELO_PASS autolearn=unavailable version=3.1.4 X-Spam-Level: To: Susan Russo <[EMAIL PROTECTED]>

[PERFORM] does VACUUM ANALYZE complete with this error?

've played 'catch up' wrt adjusting max_fsm_pages (seems to be a regular event), however am wondering if the vacuum analyze which reports the error was actually completed? Thanks Susan Russo ---(end of broadcast)--- T

Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slower than Pg7

TECTED]> To: Susan Russo <[EMAIL PROTECTED]> Cc: pgsql-performance@postgresql.org, [EMAIL PROTECTED] Subject: Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Mailing-Lis

Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slower than Pg7

>Quick reminders: >*) Did you recreate all the indexes on the new system after the initdb? >*) Did you vacuum and analyze after loading your data? No, I didn't - am reindexing db now and will run vacuum analyze afterwards. >I suggest you provide "explain analyze" output for the query o

[PERFORM] REVISIT specific query (not all) on Pg8 MUCH slower than Pg7

Pg8.1.4 server, it ran for 6 hours before I killed it (and output file was <.25 expected end size). == I'm perplexed we're not seeing better performance on Pg8.1.4 server given the 22 minutes runtime we're seeing on the Pg7.3.2 servers (on older hardware and OS). So,

Re: [PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7

:48:34 +0200 From: "Steinar H. Gunderson" <[EMAIL PROTECTED]> To: Susan Russo <[EMAIL PROTECTED]> Cc: pgsql-performance@postgresql.org, [EMAIL PROTECTED] Subject: Re: [PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7 Mail-Followup-To: Susan Russo <[EMAIL PROTECTED]&

[PERFORM] specific query (not all) on Pg8 MUCH slower than Pg7

low). A colleague who gets 1697ms on Pg8.1.4 with this query provided his postgresql.conf -- didn't help We use standard dump/load commands between these servers: pg_dump -O fb_2007_01_05 | compress > fb_2007_01_05.Z uncompress -c fb_2007_01_05.