Re: [HACKERS] a tiny question

2002-11-06 Thread Luis Alberto Amigo Navarro
I supposed it, but I've not seen 7.3. A small patch for low performance on NUMA arquitectures could be the chance of using more than one shared region. Several months away there was a brief talk about low performance on IRIX, it was not real, it's low performance on Origin servers, they use ccNUMA

Re: [HACKERS] a tiny question

2002-11-06 Thread Neil Conway
"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > Is there a way to set more than one shared regions? No, there isn't. Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC ---(end of broadcast)--- TIP 4: Don't 'kill

Re: [HACKERS] a tiny question

2002-11-06 Thread Luis Alberto Amigo Navarro
Another "tiny" question: Is there a way to set more than one shared regions? Thanks and regards ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] a tiny question

2002-11-05 Thread Luis Alberto Amigo Navarro
sday, November 05, 2002 4:47 PM Subject: Re: [HACKERS] a tiny question > "Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > > When we improve seq scans, systems scales well up to 8 cpus.When we improve index > > scan, query performance increase but system s

Re: [HACKERS] a tiny question

2002-11-05 Thread Neil Conway
"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> writes: > When we improve seq scans, systems scales well up to 8 cpus.When we improve index > scan, query performance increase but system stops scaling at about 4 proccessors, > profiling shows that it is due to increased memory contention What do y

[HACKERS] a tiny question

2002-11-05 Thread Luis Alberto Amigo Navarro
Hi all: I've been running small aplications over postgres 7.2.2, they are based over a tpch-like 100Mb database (which give us about 400Mb of disk usage), system is an 8-CPU SGI Power Challenge, postgres is given 8 shared buffers and backends 32Mb of sort-memory, so all data fits in memor