Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Newest
 Informed
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Nov
4
awarded  Informed
Oct
7
comment How is possible to configure TLSv1.1 protocol for SSL connection in PostgreSQL?
Well thank you Michael. I think @Kassandry worked harder than I did, though, and deserves some serious props here. Even going so far as to test and see that the insecure methods are indeed rejected.
Oct
7
comment Is there a way to optimize sorting by columns of joined tables?
If those fields you're sorting by aren't indexed and the data set it really large could you perhaps be looking at a sort_buffer_size issue? You could try modifying your the value on your session and run the query to see if it improves.
Oct
2
awarded  Supporter
Oct
1
answered How is possible to configure TLSv1.1 protocol for SSL connection in PostgreSQL?
Oct
1
answered Connecting to Google Cloud SQL via SSH
Aug
7
comment fighting filter (nested loops) execution plan from Oracle
I see what @sehrope is saying. And since the sub-queries aren't requesting a distinct list of 'val' from small_table it could be "reasonable" (even if not absolute) to assume that the value isn't duplicated.
Aug
6
answered fighting filter (nested loops) execution plan from Oracle
Dec
2
awarded  Teacher
Oct
7
comment Why does the query cost change so much and how to prevent it
@ChrisSaxon, If I could I'd +1 your answer I would. That's a great explanation of what's going on. I didn't really think of it that way. Thanks.
Oct
5
comment Why does the query cost change so much and how to prevent it
@ChrisSaxon, while I can appreciate that the best option is to fix the query, sometimes time doesn't allow us the luxury while our users suffer through poor performing DML. We must remain open to the options available to us. CBO is prone to problems in situations such as this...ignoring RBO when it's still available to us is a mistake. If it gets the query performing better in the short term then we have the luxury to take our time testing fixes.
Oct
3
comment Why does the query cost change so much and how to prevent it
I found another post that suggested it's better to use "where exists" instead of "where <field> in". I can't say I've tried that before, though I've seen it used once or twice.
Oct
3
answered Why does the query cost change so much and how to prevent it
Oct
3
comment Cannot start SQL SERVER SERVICE in Windows Server 2000
I can only add comments to my own answers (probably because my rep is too low since I'm a noob here) but I would think you can find a bit more info in the Dump file generated when the service crashed. That would be located in your sql server's log directory. It might tell you what it was attempting to access when it died.
Oct
2
awarded  Editor
Oct
2
revised Cannot start SQL SERVER SERVICE in Windows Server 2000
Following Max's suggestion and providing further detail
Oct
2
answered Cannot start SQL SERVER SERVICE in Windows Server 2000