Sami Dalouche wrote:
> -- For some reason, my message doesn't seem to go through the mailing
> list, so I am trying without any attachment
FWIW, you can post EXPLAIN ANALYZE results on the web here:
http://www.explain-analyze.info/
It's a pretty cool utility by Michael Glaesemann that should make
From: [EMAIL PROTECTED]
To: pgsql-performance@postgresql.org
Subject: [PERFORM]
Date: Fri, 2 Nov 2007 15:03:12 -0500
In an 8 disk configuration where 2 are used for OS; 2 for xlog, and 4 for the
database.. is this possible given Dell's possible configurations only allow 2
different RA
In an 8 disk configuration where 2 are used for OS; 2 for xlog, and 4 for the
database.. is this possible given Dell's possible configurations only allow 2
different RAID setups (SAS Raid1/Raid5)? I will also be contacting Dell, but
does this require a more advanced RAID controller that suppor
Ketema wrote:
> RAM? The more the merrier right? Understanding shmmax and the pg
> config file parameters for shared mem has to be adjusted to use it.
> Disks? standard Raid rules right? 1 for safety 5 for best mix of
> performance and safety?
> Any preference of SCSI over SATA? What about us
--On torsdag, november 01, 2007 11.34.42 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
Palle Girgensohn <[EMAIL PROTECTED]> writes:
--On torsdag, november 01, 2007 11.06.57 -0400 Tom Lane
<[EMAIL PROTECTED]> wrote:
Um, you did re-ANALYZE the table after changing the setting?
alter table lo
Hello
I am not sure, but this query will be evaluated efectivelly, because
all necessary data will be in cache.
PostgreSQL doesn't support Common Table Expressions - you can write
SRF function:
CREATE OR REPLACE FUNCTION c(integer)
RETURNS SETOF something AS $$
DECLARE r RECORD;
o something;
B
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I have the following query:
explain analyze
SELECT
(cast((
SELECT cast(row(1, o.id, NULL, NULL, NULL, NULL) as something)
FROM ONLY object o WHERE o.id = l.e
UNION ALL
SELECT cast(row(2, l2.id, l2.s, l2.e, l2.intensity, N
