[PERFORM] 8.4.4, 9.0, and 9.1 Planner Differences

2011-10-21 Thread Anthony Presley
Hi there! We have a dev machine running 9.0.1 (an i3 laptop, with a regular hard disk, with 4GB of RAM, and a mostly untuned postgresql.conf file). The changed lines are: shared_buffers = 512MB temp_buffers = 48MB work_mem = 32MB maintenance_work_mem = 348MB checkpoint_segments = 10 e

[PERFORM] explain workload

2011-10-21 Thread Radhya sahal
Hi there,, How can use explain to estimate workload contains  more than one query in the same time. such as explain (q1,q2,q3)..i want the total cost for all queries in the workload using one explain ,,?? regards..