|
"Ah, I see what you are talking about. Don't the query history statistics get written to disk and then imported though?" in TwinFin Talk • 10 replies |
17 hours ago |
|
"Actually, I poked around for a bit and it seems like you can: select * from histdb.."$hist_plan_prolog_1" p inner join histdb.."$hist_que" in TwinFin Talk • 10 replies |
1 day ago |
|
"Just checked the query history db in our environment and none of the views/tables contains an actual reference to a txid. There's a guid-lik" in TwinFin Talk • 10 replies |
1 day ago |
|
"@ Shawn - is there an indicator of when a certain transaction got executed? I'm looking for something that will tell me when a tx was ran so" in TwinFin Talk • 10 replies |
1 day ago |
|
"This just looks like your query filtering criteria... can you post the full execution/explain plan please?" in Enzee Universe • 2 replies |
1 day ago |
|
"You'd have to do it "manually" in a relational server environment. Depending on your hierarchy needs it could be anywhere between 100 record" in TwinFin Talk • 12 replies |
1 day ago |
|
"@ Shawn - I ran lspci -vv on the host and all of the interfaces came back with a Gigabit. I assume it's dual Gigabit as we have link bonds a" in Enzee Universe • 8 replies |
1 day ago |
|
"Could it be that you have new data records that are causing your process to break?" in TwinFin Talk • 3 replies |
1 day ago |
|
"I've helped the planner get a better execution plan by adding a mview on the fact table. That being said, the process recommendation is prob" in Users • 9 replies |
1 day ago |
|
"venky, I think you may need a customer login to either the website or to Netezza's FTP for the actual pdfs. If you're lucky, they may be ava" in Users • 7 replies |
1 day ago |
|
"Probably at the switch level for those ports that are connected to the rest of your servers/network. I'm not sure about the internal fabr" in Users • 7 replies |
2 days ago |
|
"I'm playing with a Twin-Fin 3 (1000-3) and I can write out to an external table pointing to /dev/null on the host at a max of 180 MB/sec. " in Enzee Universe • 8 replies |
1 week ago |
|
"Is that to be expected?" in TwinFin Talk • 13 replies |
1 week ago |
|
"Hey venky, I'd start with the Netezza documentation. I've found that it's better to start with the "System Administrators Guide" first as" in Users • 7 replies |
1 week ago |
|
"The query execution plans provide this information to an extent. I'm not sure if you can monitor that overall. Maybe Shawn would know more.." in Users • 7 replies |
1 week ago |
|
"I don't know how to do this but out of curiosity here... are you trying to monitor for large queries that are writing to the temp space or?" in Users • 4 replies |
1 week ago |
|
"One thing that you could do is tail the log via tail -f /nz/kit/log/postgres/pg.log while the sproc is running so you can see exactly whe" in TwinFin Talk • 6 replies |
1 week ago |
|
"Thanks Shawn!" in TwinFin Talk • 2 replies |
1 week ago |
|
"Nick, I was referring to the bridge table that needs to be built out "manually" by exploding the tree. If you're in a mixed database envi" in TwinFin Talk • 12 replies |
1 week ago |
|
"Do you have an actual SQL statement we can look at?" in TwinFin Talk • 6 replies |
1 week ago |
|
"Does the following work? ------------------------------------------------------------------------------ -- c) 2010 Netezza Corporation." in TwinFin Talk • 13 replies |
1 week ago |
|
"Is there a way to check the encoding of Netezza or does it default to Latin-1?" in TwinFin Talk • 0 bookmarks |
1 week ago |