[PERFORM] pg_upgrade

So we are making progress on our performance issues, we are splitting the data, changing the index value etc. So far having some success, but we also want to test out some of the options and changes in the 9 branch, but trying to dump and restore 750gb of data is not all that fun, so I'm trying to

Re: [PERFORM] Question about VACUUM

On Fri, Dec 2, 2011 at 8:32 PM, Ernesto Quiñones wrote: > Hi friends > > I want to know if it's possible to predict (calculate), how long a > VACUUM FULL process will consume in a table? > > can I apply some formula to calculate this? If you look at what iostat is doing while the vacuum full is r

[PERFORM] Question about VACUUM

Hi friends I want to know if it's possible to predict (calculate), how long a VACUUM FULL process will consume in a table? can I apply some formula to calculate this? thanks -- -- Visita : http://www.eqsoft.net -

Re: [PERFORM] Intersect/Union X AND/OR

On Fri, Dec 2, 2011 at 1:49 PM, Bruce Momjian wrote: > Thiago Godoi wrote: >> Hi all, >> >> I found this presentation from B.  Momjian: >> >> http://momjian.us/main/writings/pgsql/performance.pdf >> >> I'm interested in what he said about " Intersect/Union X AND/OR " , Can I >> find a transcriptio

Re: [PERFORM] Intersect/Union X AND/OR

Thiago Godoi wrote: > Hi all, > > I found this presentation from B. Momjian: > > http://momjian.us/main/writings/pgsql/performance.pdf > > I'm interested in what he said about " Intersect/Union X AND/OR " , Can I > find a transcription or a video of this presentation? Can anyone explain it > to

[PERFORM] Intersect/Union X AND/OR

Hi all, I found this presentation from B. Momjian: http://momjian.us/main/writings/pgsql/performance.pdf I'm interested in what he said about " Intersect/Union X AND/OR " , Can I find a transcription or a video of this presentation? Can anyone explain it to me? Thanks, Thiago Godoi