[PERFORM] Are piped columns indexable

have just 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 mailto:[EMAIL PROTECTED]> @autorevenue.c

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] question on TRUNCATE vs VACUUM FULL

y insights appreciated. Thanks, 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 mailto:[EMAIL PROTECTED]> @autorevenue.com Visit our new websit

Re: [PERFORM] question on TRUNCATE vs VACUUM FULL

that Vacuum full and truncate should provide exactly the same result. I've attached my original memo to the bottom. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Sent: Tuesday, March 18, 2008 9:11 PM To: Mark Steben Cc: pgsql-p

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 at

[PERFORM] Performance of archive logging in a PITR restore

but I am 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

[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 issue - 2 linux machines, identical configs, different performance

ates from TABLE4. So, my guess 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│Data

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 E

[PERFORM] test send (recommended by Dave Page)

send a shortened version of my 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.dom

[PERFORM] FUSION-IO io cards

times better than the spinning disks. Just wondering if anyone has had any experience with this company and these cards. We're currently at postgres 8.3.11. Any insights / recommendations appreciated. thank you, -- *Mark Steben *Database Administrator *@utoRevenue | Autobase | AVV Th