phb07 a écrit :
Dimitri a écrit :
It's probably one of the cases when having HINTS in PostgreSQL may be
very helpful..
SELECT /*+ enable_nestloop=off */ ... FROM ...
will just fix this query without impacting other queries and without
adding any additional instructions into the application co
-Ooops sorry for the spam-
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
--
HOSTIN Damien - Equipe R&D
Tel:+33(0)4 63 05 95 40
Société Axège
23 rue Saint Simon
63000 Clermont Ferrand
www.axege.com
--- Begin Message ---
Robert Haas a écrit :
On Wed, Jul 7, 2010 at 10:39 AM, damien hostin wrote:
Hello again,
At last, I check the same query with the same
Robert Haas a écrit :
On Wed, Jul 7, 2010 at 10:39 AM, damien hostin wrote:
Hello again,
At last, I check the same query with the same data on my desktop computer.
Just after loading the data, the queries were slow, I launch a vaccum
analyse which collect good stats on the main table, the
f old "from table1, table where table1.col1=table2.col1". This
way the query takes 3sec instead of 30sec. But again, without nested
loops, 200ms !
I will try later with new mondrian release and a better balanced fact
table.
Thanks anyway__
damien hostin a écrit :
Hello,
Postgresql
epesz.com/s/Yx0
I will try the same query with the same data on another server, with
"PostgreSQL 8.3.11 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.4
(Ubuntu 4.2.4-1ubuntu3)".
damien hostin a écrit :
Hello,
Before the week end I tried to change the index, but even with
Hello,
Before the week end I tried to change the index, but even with the
mono-column index on differents columns, the estimated number of rows
from dwhinv is 1.
Anyone have a suggestion, what can I check ?
thx
damien hostin a écrit :
Hello,
I try to make a query run quicker but I
Hello,
I try to make a query run quicker but I don't really know how to give
hints to the planner.
We are using postgresql 8.4.3 64bit on ubuntu 9.10 server. The hardware
is a 10 SAS drive (15k) on a single RAID 10 array with 8Go RAM.
Queries come from J2EE application (OLAP cube), but runnin
