[PERFORM] Optimize complex join to use where condition before join

g PostgreSQL 8.0 on Windows Thank you for any idea -- Kind Regards / Viele Grüße Sebastian Hennebrueder - http://www.laliluna.de/tutorials.html Tutorials for Java, Struts, JavaServer Faces, JSP, Hibernate, EJB and more. enabled seqscan and nested_loop explain analyze SELECT taufgaben.fid

Re: [PERFORM] Optimize complex join to use where condition before

_id ) patchdaten ON taufgaben.fid = patchdaten.faufgaben_id What I want to achieve is one column in my query beeing null or not null and indicating if there is a patch which includes the aufgabe (engl.: task) Is there a better way? -- Kind Regards / Viele Grüße Sebastian Hennebrueder - h

Re: [PERFORM] Optimize complex join to use where condition before

Solution not found as I thought. I integrated the query in a view and the query plan became very bad once again. The reason is that when I am using the view I have the joins in a differerent order. Does anyone have an idea to solve this. Sebastian a) bad order but the one I have in my applicatio

[PERFORM] Recommendations for set statistics

Hello, I could not find any recommandations for the level of set statistics and what a specific level does actually mean. What is the difference between 1, 50 and 100? What is recommanded for a table or column? -- Kind Regards / Viele Grüße Sebastian Hennebrueder - http://www.laliluna.de

Re: [PERFORM] Optimize complex join to use where condition before

I found a solution to improve my query. I do not know why but the statistics for all column has been 0. I changed this to 10 for index columns and to 20 for all foreign key columns. and to 100 for foreign key columns. I set the random page cost to 2 and now the query runs as expected. Many thank

Re: [PERFORM] Query plan for very large number of joins

unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Kind Regards / Viele Grüße Sebastian Hennebrueder - http://www.laliluna.de/tutorials.html Tutorials for Java, Struts, JavaServer Faces, JSP, Hibernate, EJB and more. ---(end of broadcast)-

Re: [PERFORM] tricky query

id+1) >ORDER BY t1.id LIMIT 1; > > I created a test table which has 90k randomly inserted rows. And this is > what EXPLAIN ANALYZE says: > > As Cosimo stated the result can be wrong. The result is always wrong when the id with value 1 does not exist. -- Best Regard

Re: [PERFORM] Mirroring PostgreSQL database

actually. When the backup server is to slow, it may be not important which mirroring tool you use. -- Best Regards / Viele Grüße Sebastian Hennebrueder http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB Get support, education and consulting

[PERFORM] Looking for a large database for testing

ever else. Does anybody have an idea where I can find a database like this or does even have something like this? -- Best Regards / Viele Grüße Sebastian Hennebrueder http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB Get support, education and

Re: [PERFORM] Looking for a large database for testing

Tino Wildenhain schrieb: > Sebastian Hennebrueder schrieb: > >> Hello, >> >> I would like to test the performance of my Java/PostgreSQL applications >> especially when making full text searches. >> For this I am looking for a database with 50 to 300 MB having

Re: [PERFORM] Looking for a large database for testing

Sebastian Hennebrueder schrieb: >Tino Wildenhain schrieb: > > > > >>You can download the wikipedia content. Just browse the wikimedia site. >>Its some work to change the data to be able to import into postgres, >>but at least you have a lot real world data -

Re: [PERFORM] Massive performance issues

e is going to cause much pain when inserting values >and I'm not entirely sure if I see why normalising it should cause a >massive performance improvement. > > > Just an idea: When you do not want to adapt your application to use a normalized database you may push the da

Re: [PERFORM] effizient query with jdbc

You could issue one query containing a select uuid FROM MDM.KEYWORDS_INFO WHERE KEYWORDS_ID in (xy) where xy is a large comma separated list of your values. Best Regards / Viele Grüße Sebastian Hennebrueder - http://www.laliluna.de * Tutorials for JSP, JavaServer Faces, Struts, Hibernate

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

time and be discussed and defined in a couple of days. This is of course not the correct option for a brandnew 20 spindle Sata 10.000 Raid 10 system but these are probably not the target for default configurations. If we carefully document these szenario they would we a great help for people hav

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

Josh Berkus schrieb: > Sebastian, > > >> Before inventing a hyper tool, we might consider to provide 3-5 example >> szenarios for common hardware configurations. This consumes less time >> and be discussed and defined in a couple of days. This is of course not >> the correct option for a brandn

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

Mark Kirkwood schrieb: > Josh Berkus wrote: >> Sebastian, >> >>> Before inventing a hyper tool, we might consider to provide 3-5 example >>> szenarios for common hardware configurations. This consumes less time >>> and be discussed and defined in a couple of days. This is of course not >>> the corr

Re: [PERFORM] PostgreSQL vs MySQL, and FreeBSD

> > Among other things (FreeBSD advocacy, mostly :) ), it contains a direct > comparison between MySQL and PostgreSQL on various platforms, with > PostgreSQL winning! > Hello, If the queries are complex, this is understable. I had a performance review of a Hibernate project (Java Object Relati