Re: [PERFORM] Bundling postgreSQL with my Java application

2009-07-07 Thread Kevin Grittner
Saurabh Dave wrote: > what I need to do is to check the queries that are slow and do a > vacuum analyze and share the results along with postgresql.conf > being used. Hopefully just a typo there. While you need to ensure that adequate VACUUM and ANALYZE maintenance is being performed, and a s

Re: [PERFORM] Speeding up a query.

2009-07-07 Thread Hartman, Matthew
> From: Simon Riggs [mailto:si...@2ndquadrant.com] > Sent: Tuesday, July 07, 2009 5:39 AM > > Another way would be to arrange all appointments that need odd number of > timeslots into pairs so that you have at most one appointment that needs > an odd number of timeslots. Then schedule appointments

Re: [PERFORM] Speeding up a query.

2009-07-07 Thread Simon Riggs
On Tue, 2009-06-16 at 14:35 -0400, Hartman, Matthew wrote: > The algorithm for packing appointments in respects each constraint and > typically schedules a day of treatments (30-60) within 9-10 seconds on > my workstation, down from 27 seconds initially. I would like to get it > below 5 seconds i