Re: [PERFORM] Postgres Performance on CPU limited Platforms

On Fri, Sep 12, 2008 at 12:07 PM, H. Hall <[EMAIL PROTECTED]> wrote: > > Hmmm ARM/XScale, 64MB. Just curious. Are you running a Postgres server on > a pocket pc or possibly a cell phone? > I would think SQLite would be a better choice on that kind of thing. Unless you're trying to run really com

[PERFORM] Explain Analyze - Total runtime very differentes

Hello friends ... I'm evaluating the performance of algorithms for optimization of queries. I am comparing results between the algorithm of Dynamic Programming and an implementation of Kruskal's algorithm. When submitting a query that makes reference to only 2 tables of my base, logically the same

Re: [PERFORM] Index bloat, reindex weekly, suggestions etc?

2008/10/17 Tory M Blue <[EMAIL PROTECTED]> > > The real issue is my index growth and my requirement for weekly > re-indexing (which blocks and therefore is more or less a manual > process in a live production environment (fail over, changing vips > etc). > BTW: Can't you simply recreate indexes