RES: [PERFORM] Performance on Bulk Insert to Partitioned Table

2012-12-28 Thread Luciano Ernesto da Silva
UNSUBSCRIBE De: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] Em nome de Jeff Janes Enviada em: sexta-feira, 28 de dezembro de 2012 14:31 Para: Scott Marlowe Cc: Tom Lane; Charles Gomes; Ondrej Ivanič; pgsql-performance@postgresql.org Assunto: Re: [PERF

Re: [PERFORM] Question about VACUUM

2011-12-05 Thread Ernesto Quiñones
no problem Scott, thanks for your appreciations 2011/12/5 Scott Marlowe : > On Mon, Dec 5, 2011 at 10:42 AM, Scott Marlowe > wrote: >> On Mon, Dec 5, 2011 at 10:19 AM, Ernesto Quiñones wrote: >>> vacuum_cost_delay       1s >>> vacuum_cost_limit       200 >&

Re: [PERFORM] Question about VACUUM

2011-12-05 Thread Ernesto Quiñones
Hi Kevin, comments after your comments 2011/12/3 Kevin Grittner : > Ernesto Quiñones wrote: >> Scott Marlowe  wrote: >>> Ernesto Quiñones  wrote: > >>>> I want to know if it's possible to predict (calculate), how long >>>> a VACUUM FULL process w

Re: [PERFORM] Question about VACUUM

2011-12-03 Thread Ernesto Quiñones
Thanks for the answer Scott, actually my autovacuum_naptime is 1h .. but I don't find naptime parameter for a manual vacuum thanks again 2011/12/2 Scott Marlowe : > On Fri, Dec 2, 2011 at 8:32 PM, Ernesto Quiñones wrote: >> Hi friends >> >> I want to know if it's

[PERFORM] Question about VACUUM

2011-12-02 Thread Ernesto Quiñones
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] Postgres Clustering

2009-05-27 Thread Eddy Ernesto Baños Fernández
Try Cybercluster -Mensaje original- De: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] En nombre de Alan McKay Enviado el: miércoles, 27 de mayo de 2009 13:57 Para: pgsql-performance@postgresql.org; pgsql-gene...@postgresql.org Asunto: [PERFORM]

[PERFORM] Very slow INFORMATION_SCHEMA

2008-05-02 Thread Ernesto
KEY in a database. It's PostgreSQL 8.2.7 on Fedora 8 64, Athlon 64 X2 3600+. Ernesto -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance