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)---
0 row versions in 1 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: "pg_toast_16555": found 0 removable, 0 nonremovable row versions
in 0 pages
DETAIL: 0 dead row versions cannot be
.862 calls=1
~~~ BAD.
Trigger for constraint snmp_nodes_access_nodeid_fkey: time=41.661 calls=1
Trigger for constraint stringnodeattributes_node_fkey: time=0.408 calls=1
Trigger for constraint topology_fromnode_fkey: time=0.308 calls=1
Trigger for constraint topology_tonode_fkey: time=0.
ey contraint 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
: ($1 = 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
---(e
while ( rs.next() )
System.out.println( " " + rs.getString( 1 ) );
}
rs.close();
connection.close();
---
--
______
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP
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
(in node column) 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
----
Index Scan using fki_nodes on sf_ipv4traffic x (cost=0.00..9.65 rows=1
width=6) (actual time=0.019..0.019 rows=0 loops=1)
Index Cond: (2003 = node)
Total runtime: 0.089 ms
(3 rows)
---
Any suggesions?,
thanks.
--
__
WBR, Andrew Nesheret ICQ:10518066
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
