where can i find bests practices for tunning postgresql?
_
Consigue aquí las mejores y mas recientes ofertas de trabajo en América
Latina y USA: http://latam.msn.com/empleos/
---(end of
what happend with postgresql 8.1b4 performance on query?
please help me !!!
look at this:
select count(*) from fotos where archivo not in (select archivo from
archivos)
Aggregate (cost=4899037992.36..4899037992.37 rows=1 width=0)
- Seq Scan on fotos (cost=22598.78..4899037338.07 rows=261716
I DON'T KNOW WHAT TO DO WITH THIS QUERYS...
Comparation with sql server, sql server wins !!!
Table sizes:
archivos: 40MB
fotos: 55MB
select count(1) from fotos f where not exists (select a.archivo from
archivos a where a.archivo=f.archivo)
173713 ms.
110217 ms.
83122 ms.
select count(*)
Is there something that tells postgres to take the resorces from computer
(RAM, HDD, SWAP on linux) as it need, not modifying variables on
postgresql.conf and other operating system things?
A days ago i am trying to show that postgres is better than mssql but when
execute a simple query like:
From: Ted Allen [EMAIL PROTECTED]
To: Sidar López Cruz [EMAIL PROTECTED]
CC: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Very slow queries
Date: Tue, 30 Jan 2007 16:14:38 -0500
What indexes do those tables have? Any?
Yes:
TABLE ceroriesgo.patronos ADD CONSTRAINT
From: Chad Wagner [EMAIL PROTECTED]
To: Sidar López Cruz [EMAIL PROTECTED]
CC: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Very slow queries
Date: Tue, 30 Jan 2007 17:37:17 -0500
On 1/30/07, Sidar López Cruz [EMAIL PROTECTED] wrote:
query: Delete From ceroriesgo.salarios Where
is another variation that may help.
Delete From ceroriesgo.salarios Where numero_patrono In (Select
ceroriesgo.salarios.numero_patrono From ceroriesgo.salarios Left Join
ceroriesgo.patronos Using (numero_patrono) Where
ceroriesgo.patronos.numero_patrono Is Null)
Hope that Helps,
Ted
Sidar López Cruz
From: Ted Allen [EMAIL PROTECTED]
To: Sidar López Cruz [EMAIL PROTECTED]
CC: pgsql-performance@postgresql.org, [EMAIL PROTECTED]
Subject: Re: [PERFORM] Very slow queries
Date: Wed, 31 Jan 2007 09:32:43 -0500
How many rows were delete last time you ran the query?
Chad's query looks good