Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-16 Thread Rodrigo De León
On 8/16/06, Peter Hardman [EMAIL PROTECTED] wrote: I'm in the process of migrating a Paradox 7/BDE 5.01 database from single-user Paradox to a web based interface to either MySQL or PostgreSQL. The database is a pedigree sheep breed society database recording sheep and flocks (amongst other

Re: [PERFORM] query plan worse after analyze

2007-10-05 Thread Rodrigo De León
On 10/5/07, Stephen Frost [EMAIL PROTECTED] wrote: ... (perhaps a pastebin like http://pgsql.privatepaste.com) ... This is cool. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [PERFORM] SQL Monitoring

2007-10-10 Thread Rodrigo De León
On 10/10/07, Tomáš Vondra [EMAIL PROTECTED] wrote: Actually we wrote something similar as pgfounie was not as nice as today, at that time (2005] - you can find that tool on http://opensource.pearshealthcyber.cz/. Actually I'm working on a complete rewrite of that tool into Java (new features,