If you supply the following: 1. The schema (including available indexes) for each table in the query 2. The actual query 3. The row counts for the tables via select count(*)
I suspect that someone can formulate a query that is as fast as you need. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk > Sent: Friday, August 20, 2004 2:01 AM > To: Lista dyskusyjna pgsql-general > Subject: [GENERAL] Help with optimizing query > > > Hello, > I have a query, which is quite big and there is a huge difference > between execution time in MySQL and PostgreSQL. I think that > I have made > all possible steps to increase the speed of the query, but > unfortunately > it is still about 100 times slower. I'm out of ideas what > to do next, > so maybe you will point me what shall I do. In the attachment > I send you > the result of "explain analyze". > > I will be appreciated for any help. Thanks in advance. > > ML > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
