Como vez ou outra surge o assunto "performance" por aqui, segue uma mensagem enviada para listas do freebsd a respeito do desempenho do PostgreSQL.
Boa leitura... ----- Forwarded message from Konstantin Belousov <kostik...@gmail.com> ----- Date: Wed, 16 Jul 2014 16:29:38 +0300 From: Konstantin Belousov <kostik...@gmail.com> To: performa...@freebsd.org, curr...@freebsd.org Subject: Re: PostgreSQL performance on FreeBSD On Fri, Jun 27, 2014 at 03:56:13PM +0300, Konstantin Belousov wrote: > Hi, > I did some measurements and hacks to see about the performance and > scalability of PostgreSQL 9.3 on FreeBSD, sponsored by The FreeBSD > Foundation. > > The results are described in https://kib.kiev.ua/kib/pgsql_perf.pdf. > The uncommitted patches, referenced in the article, are available as > https://kib.kiev.ua/kib/pig1.patch.txt > https://kib.kiev.ua/kib/patch-2 A followup to the original paper. Most importantly, I identified the cause for the drop on the graph after the 30 clients, which appeared to be the debugging version of malloc(3) in libc. Also there are some updates on the patches. New version of the paper is available at https://www.kib.kiev.ua/kib/pgsql_perf_v2.0.pdf The changes are marked as 'update for version 2.0'. ----- End forwarded message ----- -- Ricardo Campos Passanezi - Supervisor de Seção Chave PGP e GPG Pública em: http://www.ige.unicamp.br/~riccp Instituto de Geociências - http://www.ige.unicamp.br - UNICAMP Tel: (19) 3521 4560 _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
