Reputation
8,941
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~452k people reached

4h
comment Extremely slow query on indexed column
Does it stay the same after doing an ANALYZE orders;?
7h
comment How to model an activity feed
Could you be more specific? Apart from the mentioned answer, what other solutions are worth mentioning?
8h
comment Connection Failure for postgres at Talend Open Studio
@Jeevitha if you connected like that, you did it through a socket - this is usually not the way fancy clients support. What do you get if you specify -h localhost with psql, too?
1d
comment MySQL BEFORE INSERT trigger with IF conditions
NumberHP = null will be never true as nothing is equal to NULL
1d
comment How can I take table as input dynamically from user?
Try to figure out if your problems can be solved using dynamic SQL. Otherwise, you don't tell us how (directly connected to the DB, through an application, other) the users issue these queries.
1d
comment Database design help required
What are all those names? And where do the first and last execution IDs come from? You want probably describe your real world problem in a bit more detail.
1d
comment Finding out what permissions are required by the SQL Server Agent Jobs
How does it work for finding the necessary permissions?
Aug
18
comment Mysql - How to Optimize Retrieval Time in a Table
What do you expect from this?
Aug
7
comment Materialized View does not reflect changes after fast refresh
It looks like a `count(b) is missing, see docs.oracle.com/cd/B19306_01/server.102/b14223/…
Aug
7
comment simple mysql query design help
Check out how to pivot. There are many examples here: dba.stackexchange.com/questions/tagged/pivot+mysql
Aug
7
comment How to call Oracle Function from POSTGRESQL
I am not exactly sure how to do it, but I think you could write a pl/python function (other untrusted languages might fit, too) to achieve it. You could also try github.com/atris/JDBC_FDW - again, not sure if it can help (what I read there, it should, but never tried).
Aug
6
comment is it “bad” to bulk update a boolean column semi-regularly on potentially a large set of records in Postgres?
In a scheduled job I wouldn't use VERBOSE with VACUUM ANALYZE as there are chances that nobody, ever checks the output...
Aug
6
comment Last user update for a table
Which RDBMS are you on?
Aug
6
comment How to generate a JSON file from stored procedure(SQL) result
Are you on Oracle?
Aug
6
comment Help with recursing self-referencing table
How does (VariableId = 1) relate to (DataSourceId = 1)? Your table definitions don't suggest such connection, the example output has it, though.
Aug
5
comment Postgres query timing divergence
@a_horse_with_no_name and the rendering, too, if I'm not mistaken
Aug
5
comment How to reclaim space taken by an index that partially built and was terminated by a power outage
Do you have anything in the list that SELECT indexrelid::regclass, indrelid::regclass FROM pg_catalog.pg_index WHERE NOT indisvalid; gives you?
Aug
4
comment Why seq-scan can be much faster than index-scan and index-only-scan in this simple query?
Hm, now I found an excellent post from Robert Haas, where he describes these in detail. I have to admit you are right - index-only scans are not always index-only, but they try as long as it is possible. At the same time, an index-only scan with additional heap fetches is possible when a sufficient portion of the table pages remains unchanged since the last vacuum.
Aug
4
comment How To Manage Random Data Without Repitition?
Please format your tables properly, it's not very easy to follow this way.
Aug
3
comment Postgres query plan has high rowcount, slow execution
Could you show the definition of those composite indexes?