Reputation
15,099
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 56
Impact
~936k people reached

6h
comment Locking in Postgres for UPDATE / INSERT combination
Check out advisory locks: postgresql.org/docs/current/static/…
6h
comment Postgres 9.4.4 Query Hangs Forever
Try ... WHERE (id, group_number) NOT IN (select id, group_number from table_two) ... instead of using the concatenated values. That might be able to use a combined index on the columns. You can also try to rewrite the NOT IN into a NOT EXISTS co-related subquery, sometimes that performs better.
6h
comment Postgres 9.4.4 Query Hangs Forever
wiki.postgresql.org/wiki/Slow_Query_Questions
6h
reviewed Approve Postgres 9.4.4 Query Hangs Forever
14h
comment MySQL: not quoting WHERE conditions slows query execution
Those two statement are not doing the same thing. The first one compares the column parm1 to the column taleggio and the column parm2 to the _column` gorgonzola. So the first one will not run unless you have those two columns. The second one compares the column parm1 to the _constant value 'taleggio'
15h
comment Where to place a foreign key column?
This is all about coding standards. The usual answer is: pick one and stick to it.
15h
comment Where to place a foreign key column?
The order of columns in a relational table is irrelevant.
15h
comment ERROR: no schema has been selected to create in
Maybe your user doesn't have the necessary privileges to create tables in the public schema.
15h
revised ERROR: no schema has been selected to create in
edited tags
16h
revised how to avoid duplicate record with certain conditon
added 41 characters in body
16h
awarded  Popular Question
17h
revised MySql Lock Tables Blocking Logic
edited tags
19h
revised Optimize a SQL query
edited tags
20h
revised how to create trigger in SQL server using two tables to find stock quantity
edited tags
21h
revised How to create a custom map report
edited tags
22h
comment How to partition existing table in postgres?
For just few million rows I don't think partitioning is actually necessary. Why do you think you need it? What problem are you trying to solve?
22h
revised Creating a stored procedure and adding date manually to filename
edited tags
Jul
3
awarded  Good Answer
Jul
3
revised Automatic failover mechanism for PostgreSQL
deleted 43 characters in body
Jul
3
reviewed Approve How to join more than one table