[PERFORM] VACUUM ANALYZE downgrades performance

2004-11-30 Thread Dmitry Karasik
7;run vacuum analyze each 5 seconds'. -- Sincerely, Dmitry Karasik --- catpipe Systems ApS *BSD solutions, consulting, development www.catpipe.net +45 7021 0050 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to

Re: [PERFORM] VACUUM ANALYZE downgrades performance

2004-12-02 Thread Dmitry Karasik
d on a table when it is empty, are suddenly applied when it is full. -- Sincerely, Dmitry Karasik --- catpipe Systems ApS *BSD solutions, consulting, development www.catpipe.net +45 7021 0050 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PERFORM] VACUUM ANALYZE downgrades performance

2004-12-03 Thread Dmitry Karasik
t 8.0 beta to come out, or Rod> against CVS. Tom recently applied some changes which should mitigate Rod> this situation. But this would affect only VACUUM, and not ANALYZE, right? -- Sincerely, Dmitry Karasik --- catpipe Systems ApS *BSD solutions, consulting, development www.catpipe.

[PERFORM] seqscan on UNION'ed views

2013-02-27 Thread Dmitry Karasik
hich can't rewrite joins in such a way automatically, and there are so many of those automated queries that rewriting them by hand is also a rather bad alternative. So my question is, is it possible to somehow nudge the planner into the right direction? Thank you in advance! -- Sincerely,