Re: [PERFORM] GROUP BY Vs. Sub SELECT

2006-04-24 Thread Bruno Almeida do Lago
output... where can I read more about it? Thank you very much for your attention!! Regards, Bruno -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Sunday, April 23, 2006 8:34 PM To: Bruno Almeida do Lago Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] G

[PERFORM] GROUP BY Vs. Sub SELECT

2006-04-23 Thread Bruno Almeida do Lago
Hi, I'm just getting familiar with EXPLAIN ANALYZE output, so I'd like to get some help to identify which one of the following queries would be better: teste=# EXPLAIN ANALYZE SELECT aa.avaliacao_id, MAX(aa.avaliacao_versao) AS avaliacao_versao, a.avaliacao_nome, aa.editar teste-# FROM teo01tb104

Re: [PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

2005-02-24 Thread Bruno Almeida do Lago
No problems my friend :P I thought that since the beginning and just sent the e-mail to confirm if there was no software limitation. Best Wishes, Bruno Almeida do Lago -Original Message- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 6:02 PM To

Re: [PERFORM] Peformance Tuning Opterons/ Hard Disk Layout

2005-02-23 Thread Bruno Almeida do Lago
Is there a real limit for max_connections? Here we've an Oracle server with up to 1200 simultaneous conections over it! "max_connections: exactly like previous versions, this needs to be set to the actual number of simultaneous connections you expect to need. High settings will require more shared

[PERFORM] Very important choice

2005-02-01 Thread Bruno Almeida do Lago
this right? How much this difference affects performance and integrity?   I don't have experience with FreeBSD so I'd like to know if it is possible to run XFS on FreeBSD 5.3.     Thank you, Bruno Almeida do Lago  

Re: [PERFORM] PostgreSQL clustering VS MySQL clustering

2005-01-20 Thread Bruno Almeida do Lago
I was thinking the same! I'd like to know how other databases such as Oracle do it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitch Pirtle Sent: Thursday, January 20, 2005 4:42 PM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] PostgreS

Re: [PERFORM] PostgreSQL clustering VS MySQL clustering

2005-01-20 Thread Bruno Almeida do Lago
Bruno Almeida do Lago -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hervé Piedvache Sent: Thursday, January 20, 2005 1:31 PM To: Merlin Moncure Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] PostgreSQL clustering VS MySQL clustering Le Jeu