Re: [PERFORM] Explain Doc
On Mon, 08-sep-2003 at 16:29, Rhaoni Chiu Pereira wrote: > Could anyone tell me a documentation that explains the " explain " result > and how to analyze it ? > http://archives.postgresql.org/pgsql-performance/2003-09/msg0.php Regards, -- Alberto Caso Palomino Adaptia Soluciones Integrales http://www.adaptia.net [EMAIL PROTECTED] signature.asc Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente
Re: [PERFORM] SQL performance problems
On Mon, 01-09-2003 at 13:42, Rhaoni Chiu Pereira wrote: > I've done that but it didn't make much difference. > Do you know some documentation on explain ? I don't understand the results.. > http://developer.postgresql.org/docs/postgres/sql-explain.html http://developer.postgresql.org/docs/postgres/performance-tips.html Also this list's archives (which can be found at http://archives.postgresql.org/pgsql-performance/ ) are a good source of info on the subject. Best Regards, -- Alberto Caso Palomino Adaptia Soluciones Integrales http://www.adaptia.net [EMAIL PROTECTED] signature.asc Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmadadigitalmente
Re: [PERFORM] SQL performance problems
Hi, Estimated and actual rows differ a lot. Did you a VACUUM ANALYZE so that the optimizer could update its statistics? Also it would be great if you could provide more information, as your PostgreSQL version, your table and indexes descriptions, etc. Have a look at: http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines Please excuse me if you have already done it. I had a quick look at the list's archives and didn't found it in your prior posts. Regards, -- Alberto Caso Palomino Adaptia Soluciones Integrales http://www.adaptia.net [EMAIL PROTECTED] signature.asc Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmadadigitalmente
