= node)
Total runtime: 445145.901 ms
(3 rows)
PS: Test 2 is more applicable, for both types of nodes
a) for nodes with no statistics
b) for nodes with statistics in sf_ipv4traffic too.
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end
is restrict (i'm
understand this is very important).
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
=0.408 calls=1
Trigger for constraint topology_fromnode_fkey: time=0.308 calls=1
Trigger for constraint topology_tonode_fkey: time=0.277 calls=1
Total runtime: 64814.359 ms
~~~ BAD.
(12 rows)
ROLLBACK
--
__
WBR, Andrew Nesheret ICQ:10518066
pages contain useful free space.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.01 sec.
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
and this test has exclusive access to postgres and no
other activites on this system.
Thank you Richard! And my question is. What should i do further ?
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP 5
) and
this node never deleted
ALL 15 millions rows referenced to node 156
inms= select node from sf_ipv4traffic limit 10;
node
--
156
156
156
156
156
156
156
156
156
156
(10 rows)
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end
Richard Huxton wrote:
Andrew Nesheret wrote:
Richard Huxton wrote:
If you PREPARE then EXECUTE the same query, does it still use
the index?
Tested, comments?
--- code -
--- result ---
Result for node #2007
Index Scan using fki_nodes on sf_ipv4traffic x (cost=0.00..9.65
rows=1
() )
System.out.println(+ rs.getString( 1 ) );
}
rs.close();
connection.close();
---
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
?,
thanks.
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq