John W Strange wrote:
http://www.fusionio.com/products/iodrive/ - BEST in slot currently IMHO.
http://www.intel.com/design/flash/nand/extreme/index.htm?wapkw=(X25-E) - not a
bad alternative.
The FusionIO drives are OK, so long as you don't mind the possibility
that your system will be
Benjamin Krajmalnik wrote:
I am already having serious I/O bottlenecks with iostat -x showing extended
periods where the disk subsystem on the data partition (the one with all the
random i/o) at over 85% busy. The system is running FreeBSD 7.2 amd64 and
PostgreSQL 8.4.4 on
Pessoal,
Estou com uma dúvida ao fazer Tunning no arquivo de configuração do
Postgres.
Minha aplicação tem varios acessos simultâneos, chegando picos de 2000 mil
ou até mais. Por ser uma aplicação Web fica dificil de se estipular o
max_connections, sem contar que o restante dos parâmetros faz
Hi,
I have a performance trouble with UNION query
First I have this view :
SELECT a,b,c FROM table1, table2 WHERE jointure AND condition
Result : 150 000 records in 1~2 s
Then, I adding an UNION into the same view :
SELECT a,b,c FROM table1, table2 WHERE jointure AND
Hello,
UNION will remove all duplicates, so that the result additionally
requires to be sorted.
Anyway, for performance issues, you should always start investigation
with explain analyze .
regards,
Marc Mamin
From: pgsql-performance-ow...@postgresql.org
Marc Mamin m.ma...@intershop.de wrote:
Hello,
UNION will remove all duplicates, so that the result additionally requires to
be sorted.
Right, to avoid the SORT and UNIQUE - operation you can use UNION ALL
Anyway, for performance issues, you should always start investigation with
