Re: [PERFORM] Select in subselect vs select = any array

2011-03-19 Thread Pavel Stehule
Hello 2011/3/20 Adam Tistler : > I have noticed that SELECT ... = ANY(ARRAY(...))  is about twice as fast as > SELECT IN ( ... ). > Can anyone explain a reason for this?  Results are the bottom and are > reproducible.  I can test with other versions if that is necessary. > send a result of EXPL

[PERFORM] Select in subselect vs select = any array

2011-03-19 Thread Adam Tistler
I have noticed that SELECT ... = ANY(ARRAY(...)) is about twice as fast as SELECT IN ( ... ). Can anyone explain a reason for this? Results are the bottom and are reproducible. I can test with other versions if that is necessary. ./configure --prefix=/usr/local/pgsql84 --with-openssl --with-p

Re: [PERFORM] Fastest pq_restore?

2011-03-19 Thread bricklen
On Thu, Mar 17, 2011 at 7:25 AM, Michael Andreasen wrote: > Currently I am using a twin processor box with 2GB of memory and raid 5 > disk. > I start postgres before my load with these settings, which have been > suggested. > > I restore like this; > pg_restore -Fc -j 4 -i -O -d my_db my_db_dump.t

Re: [PERFORM] Performance on AIX

2011-03-19 Thread Andy Colson
On 03/19/2011 04:00 AM, phb07 wrote: Hi all, At Bull company, we want to answer a call for tender from a large company. And we are asked for information about PostgreSQL performance under AIX on Power 7 servers. By chance, has someone some data about this ? Has someone performed a benchmark u

[PERFORM] Performance on AIX

2011-03-19 Thread phb07
Hi all, At Bull company, we want to answer a call for tender from a large company. And we are asked for information about PostgreSQL performance under AIX on Power 7 servers. By chance, has someone some data about this ? Has someone performed a benchmark using AIX quite recently ? Are there