[PERFORM] test send (recommended by Dave Page)

query later. Thank you, Mark Steben | Database Administrator http://www.autorevenue.com @utoRevenueR - Keeping Customers Close 95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) http://www.dominionenterprises.com @utoRevenue is a registered trademark

[PERFORM] Performance issue - 2 linux machines, identical configs, different performance

is the disparity of performance (40 seconds vs 180 seconds) has to do with MACHINE2 not Availing itself of hash joins which by my understanding is much faster. Any help / insight appreciated. Thank you Mark Steben│Database Administrator│ @utoRevenue-R

Re: [PERFORM] Performance issue - 2 linux machines, identical configs, different performance

Yes I analyze after each replication. Mark Steben│Database Administrator│ @utoRevenue-R- Join the Revenue-tion 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion Enterprises

[PERFORM] Performance discrepancy

-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Performance of archive logging in a PITR restore

pretty much out of ideas to make this work. Mark Steben│Database Administrator│ @utoRevenue-R- Join the Revenue-tion 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion Enterprises

Re: [PERFORM] question on TRUNCATE vs VACUUM FULL

or an email address that I could bring evidence to? Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax [EMAIL PROTECTED] Visit our new website

[PERFORM] question on TRUNCATE vs VACUUM FULL

, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben blocked::mailto:[EMAIL PROTECTED] @autorevenue.com Visit our new website at blocked::http

Re: [PERFORM] performance tools

Toad Data Modeler from Quest Software is an E/R diagram tool that works for us. And - it has a freeware version. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809

[PERFORM] Are piped columns indexable

gotten sequential scans Thanks for your time Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben blocked::mailto:[EMAIL PROTECTED] @autorevenue.com