[PERFORM] UPDATE execution time is increasing

Hello! I would like to ask following question: I have created a table and I updated all records. And I executed this update command again and again Execution time was growing after each step. I cannot understand this behavior. First update command took 6 sec, 30th update (same) command took 3

Re: [PERFORM] Is there an equivalent for Oracle's user_tables.num_rows

optimizer perceived rows Other more accurate heuristics like relative distribution of columns would be harder to track in the application, and I'd rather let the database do that by issuing the analyze Regards, Virag - Original Message - From: "Tom Lane" <[EMAIL PROTE

[PERFORM] Is there an equivalent for Oracle's user_tables.num_rows

optimizer believes the number of rows are ? The tables in question have multi-column primary keys. Regards, Virag

Re: [PERFORM] Cost Issue - How do I force a Hash Join

am_heapobj bo (cost=0.00..4.33 rows=1 width=43) (actual time=0.294..0.300 rows=1 loops=6259) Index Cond: ((bo.heap_id = 0) AND (bo.objaddr = "outer".childaddr)) Total runtime: 9950.192 ms Regards, Virag - Original Message - From: "Tom Lane" <[EMAIL

[PERFORM] Cost Issue - How do I force a Hash Join

ime=0.018..0.022 rows=1 loops=6259)    Index Cond: ((bo.heap_id = 0) AND (bo.objaddr = "outer".childaddr)) Total runtime: 566044.187 ms(21 rows) Regards,   Virag

Re: [PERFORM] Avoiding cartesian product

..2.01 rows=1 width=8) (never executed)   Index Cond: (22 = trace_id) Regards,   Virag - Original Message - From: "Szűcs Gábor" <[EMAIL PROTECTED]> To: <pgsql-performance@postgresql.org> Sent: Monday, January 09, 2006 7:59 AM Subject: Re: Avoiding cartesian product &g

[PERFORM] Avoiding cartesian product

I have a table which stores cumulative valuesI would like to display/chart the deltas between successive data collections   If my primary key only increments by 1, I could write a simple query   select b.gc_minor - a.gc_minor, b.gc_major - a.gc_major  from jam_trace_sys a, jam_trace_sys b wh

[PERFORM] ERROR: no value found for parameter 1 with JDBC and Explain Analyze

.executeQuery(AbstractJdbc2Statement.java:240) at jsp._testexplain_2ejsp._jspService(_testexplain_2ejsp.java:82) at org.gjt.jsp.HttpJspPageImpl.service(HttpJspPageImpl.java:75) Regards, Virag ---(end of broadcast)--- TIP 5: don't forge