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
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
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
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
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