Reputation
15,079
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 28 55
Impact
~931k people reached

Jun
11
revised Wrong results from joining two CTEs
edited tags
Jun
10
reviewed Approve Can I Show Multiple “WHERE” Filtered Results In A Single Query/Output Table?
Jun
10
answered Can I Show Multiple “WHERE” Filtered Results In A Single Query/Output Table?
Jun
10
revised Can I Show Multiple “WHERE” Filtered Results In A Single Query/Output Table?
psql is the commandline client, the DBMS is called Postgres
Jun
9
revised How to check/know the highest run queries
edited tags
Jun
9
comment How to check/know the highest run queries
postgresql.org/docs/current/static/pgstatstatements.html
Jun
9
comment SQL Server DOUBLE keyword
You most probably don't want to use double (or float or real) anyway: floating-point-gui.de
Jun
9
comment How can we configure the Streaming Replication(master-slave) on single SAN storage in PostgreSQL?
You configure it the same way as any other replication configuration. Have two Postgres servers where the masters streams the WAL files to the slave - you just need to make sure that master and slave use different data directories.
Jun
8
revised Postgres DB user permission
edited tags
Jun
8
comment Speed up creation of Postgres partial index
"Autovacuums are turned OFF" - why? That is a really bad idea. This prevents the collecting of statistics and thus will yield bad query plans
Jun
8
reviewed Edit Online index rebuild snapshot location and impact of filling index drive
Jun
8
revised Online index rebuild snapshot location and impact of filling index drive
minor spelling and improved tagging
Jun
8
revised How to organize long Query
edited tags
Jun
8
comment Count of distinct values of a table using sql
@Colin'tHart: that's why I said the question should be tagged with the appropriate DBMS.
Jun
8
comment Count of distinct values of a table using sql
Although not relevant for such a basic question, you should always add the tag for your DBMS (postgresql, oracle, ...)
Jun
8
answered Count of distinct values of a table using sql
Jun
8
revised Count of distinct values of a table using sql
added 66 characters in body
Jun
7
comment the cache hit rate using pg_statio_user_tables
First: a ration of 0.44 is 44% - but I would think the ratio should be calculated: using sum(heap_blks_hit) / sum(heap_blks_read)
Jun
6
revised Get available first booking date in my system
edited tags
Jun
5
comment Cannot rename database (the user in --username is the owner)
Which is exactly what the error message told you...