Posts by Neto • 611 points
7 posts
-
0
votes1
answer76
viewsA: Save text with line breaks in BD
After a few tests, I’ll answer my own question: The solution was to insert System.getProperty("line.separator"); in each iteration of the While loop, see: String variavel =…
-
0
votes1
answer76
viewsQ: Save text with line breaks in BD
See below for a java code to save an SQL command return in Postgresql. The command is EXPLAIN ANALYZE. The problem is that while saving this in the database, it loses line breaks. Someone would know…
-
1
votes0
answers51
viewsQ: Help tool in Postgresql . conf configuration
someone knows some tool that assists in adjusting the parameters of the postgresql.conf file. I’ve used the PGTUNE and of Pgconfig, but they indicate nothing of the parameters: cpu_tuple_cost…
-
48
votes0
answers1178
viewsQ: Why are cost estimates in Postgresql so wrong?
Could someone help me understand why Postgresql missed several cost estimates in an experiment I did. I’m doing an experiment with 22 darlings of Benchmark TPCH[1], to verify index performance in…
-
0
votes1
answer340
viewsA: How to search for a string that varies from position
I almost managed to solve the problem with Regular Expression. See below what I did: select substring('Aggregate (cost=27726324.40..27726324.41 Rows' from '[.][0-9]+.?[0-9]{2}'); -------- RESULT .…
-
1
votes1
answer340
viewsQ: How to search for a string that varies from position
See below two results returned from a table where I store sqls query execution plan. I use POSTGRESQL I need to capture only the string cost=399301.55 of the result below. The word cost always comes…
-
1
votes1
answer199
viewsQ: Selective reading of an XML
I’m able to read an XML but there’s more stuff I don’t need. The problem is that my XML source file has repeated tags in such a hierarchy (see the PLAN tag that repeats): <explain>…