[flymine-dev] Re: [release 3.1 webapp build]

[flymine-dev@flymine.org]

it's now only a little bit faster, not fast enough...

how do I set the max time?




> --- Ursprüngliche Nachricht ---
> Von: Richard Smith <richard@flymine.org>
> An: AlexanderP@gmx.at
> Kopie: flymine-dev@flymine.org
> Betreff: [flymine-dev] Re: [release 3.1 webapp build]
> Datum: Thu, 15 Dec 2005 11:13:44 +0000
> 
> Yes, that is exactly the problem.  We have our max time set to
> 1000000000 but in your case I think that still wouldn't help.
> This limit is imposed to prevent poorly constrained queries run
> in a production environment from clogging up the database
> server for too long.  When releasing the webapp it could be set
> as high as you like.
> 
> A better option is to get the query to run a bit faster.  Have
> you done an analyse on the restored dump?  We set our
> default_statistics_target to 200.
> 
> Explanation if you haven't done much with postgres before:
> Statistics are stored about each table (number of rows, etc)
> and are used by the postgres query planner to choose sensible
> queriy methods.  Whenever you restore a dump or significantly
> alter the contents of the database you should run "analyse;" in
> psql. 
> 
> default_statistics_target is a number between 1 and 1000 that
> governs how precise the statistics are (default is 10).  High
> numbers lead to slightly longer spent planning but should
> result in more efficient queries.
> 
> So, you should try:
>  > set default_statistics_target 200;
>  > analyse;
> 
> The value is set only for a particular session, to see value:
>  > show default_statistics_target;
> 
> It is better to set the in postgresql.conf and restart postgres.
> 
> 
> Then try building the webapp again.  Hope this helps,
> Richard.
> 
> 
> 
> 
> AlexanderP@gmx.at wrote:
> 
> >here it is,
> >
> >ausgabe is the normal output
> >errausgabe are the error messages...
> >(attached)
> >
> >maybe it's only the Estimated time to run query greater than maximum...?
> >
> >>from command:
> >nice nohup ant -v build-production-webapp >ausgabe.dat 2>errausgabe.dat
> ></dev/null &
> >
> >kind regards,
> >   alex
> >
> >
> >
> >
> 
> 
> _______________________________________________
> flymine-dev mailing list
> flymine-dev@flymine.org
> http://mailman.flymine.org/listinfo/flymine-dev

-- 
10 GB Mailbox, 100 FreeSMS/Monat http://www.gmx.net/de/go/topmail
+++ GMX - die erste Adresse für Mail, Message, More +++