« first day (463 days earlier)      last day (1111 days later) » 

McNets
McNets
2:48 PM
1
Q: Coverting MongoDB timestamp to postgres

Data TaleI have an export of MongoDB data that includes time stamp such as lastRunEnd = 1549036780246 When I select this value as select to_timestamp (('1549036780246'::double precision)) as lastRunEnd I get: 51057-01-08 05:30:46 Where I expect 2019-02-01 15:59:40.... Here is value as written in Mon...

postgresql mongodb
0
Q: Syntax Error on Set Clause in Update Query

speedfranklinThis seems like a simple query, but currently it returns a syntax error: UPDATE tablename SET description = "a nice description" WHERE tableid = 2; The error I get says: ERROR: column "a nice description" doesn't exist My statement looks like what I see in the documentation, except that I'm...

postgresql syntax
-3
Q: How can I resolve Index scans?

pete_adamsAnalysis of index usage shows some that are used frequently with scans vs seeks. I need to find how to determine what to change to turn the scan into a seek. Example in the last 24 days, the index IX_EXPLORE_CALL_4 on the explore_call table seeks 19,938 scans 74,407,434 update 32,404 rows 135,78...

index-tuning performance-tuning
^^^^ Apparently it cannot be deleted
 
Andriy M
Andriy M
3:32 PM
@McNets Not sure what the problem is, I can see the delete link. But I don't think it's time to delete it yet. The OP has been given some suggestions in the comments that he hasn't seen yet. Perhaps we should give him some more time to improve the Q. If he chooses not to, the system will eventually delete it anyway.
 
McNets
McNets
@AndriyM It seems that some question closed as duplicated, points to it. But, you're right we can wait.
 

« first day (463 days earlier)      last day (1111 days later) »