Re: [PERFORM] Training Recommendations

2007-12-03 Thread Joshua D. Drake
On Fri, 30 Nov 2007 04:15:09 -0500 Robert Treat <[EMAIL PROTECTED]> wrote: > Never take advice from a guy who top posts... A friend of mine just > went through an OTG course and had good things to say, and I've heard > other speak well of it too, so I'd probably recommend them, but there As a CM

Re: [PERFORM] Dealing with big tables

2007-12-03 Thread Merlin Moncure
On Dec 2, 2007 7:35 AM, Mindaugas <[EMAIL PROTECTED]> wrote: > I'd like this query to respond under a specific time limit. 5s now is OK > but 50s later for 1 rows is too slow. > > Also off list I was pointed out about covering indexes in MySQL. But they > are not supported in PostgreSQL,

Re: [PERFORM] Training Recommendations

2007-12-03 Thread Robert Treat
On Sunday 02 December 2007 15:26, Usama Munir Dar wrote: > Robert Treat wrote: > > On Wednesday 28 November 2007 11:20, Usama Munir Dar wrote: > >> EnterpriseDB (www.enterprisedb.com), ofcourse > > > > lame :-P > > Have you or anyone you know tried the training offerings? or you think > its lame be

Re: [PERFORM] Training Recommendations

2007-12-03 Thread Paul Lindner
At hi5 we had the pleasure of having Enterprise DB provide a two-day training seminar for our DBA and operations staff. Everyone was very satisfied with the quality and the price. On Mon, Dec 03, 2007 at 01:26:58AM +0500, Usama Munir Dar wrote: > > > Robert Treat wrote: >> On Wednesday 28 Novembe

Re: [PERFORM] Dealing with big tables

2007-12-03 Thread Matthew
On Mon, 3 Dec 2007, Mark Kirkwood wrote: > > And I cannot use some index organized table or table partitioned by > > From :) because there are at least 2 similar indexes by which queries > > can be executed - From and To. > This makes things a bit tough. One trick is to vertically partition the >