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 table

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 November

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 because i top

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, aren't

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 CMD