11,143 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 8 mins ago

Jun
23
comment Issue working with Postgres on Windows
But according to the manual -f should be equivalent to \i
Jun
23
comment How to improve query performance in PostgreSQL?
Ah, sorry. That was a typo. It should of course be work_mem
Jun
23
comment General tuning in PostgreSQL
wiki.postgresql.org/wiki/Performance_Optimization
Jun
23
comment Maximum limit for COPY FROM STDIN in postgres
What is a "4 lakh file"?
Jun
23
comment How to improve query performance in PostgreSQL?
Increase your sort_mem. For testing purposes you can do that for the current connection using set. Also: unless you are running Postgres on a smartphone, 128MB for shared_buffers is way to small. The general rule of thumb is 25% of the main memory
Jun
11
comment Oracle database startup fails several times. Giving ksvcreate
"then as usual I shut down abort my database" - that is a terrible way to do "usually". shutdown abort should be the last resort. shutdown immediate should be the "usual" way of shutting down Oracle.
Jun
11
comment pgAdmin goes “out of memory” with large queries
A 32bit process can't allocate more than approx. 3gb of memory. You will need to use the 64bit version if you need more memory for pgAdmin
Jun
10
comment Limiting read access in postgres to few rows
You might be able to do that using rules: postgresql.org/docs/current/static/rules-views.html
Jun
9
comment Extremely long query time after upgrading to Postgres 9.3 from 9.1
Can you also post the explain analyze output for 9.1?
Jun
5
comment Import using pgAdmin3 produces ERROR: duplicate key value violates unique constraint
If your CSV import supplies a value for the daqa_report_id then that won't increment the sequence. You need to manually adjust the sequence after such an import. Search for "setting sequence value in postgres"
Jun
4
comment Postgresql - How to Convert all Column Names to Lowercase
Just do the same thing for the column names from information_schema.columns
Jun
4
comment Mysql Connection Pooling Similar To PostgreSQL's PgBouncer
And how does that answer the question if something similar exists for MySQL?
Jun
3
comment Find the user with closest taste of mine
Added mysql tag based on the SQLFiddle
Jun
2
comment PostgreSQL Failover strategy
Cross post: stackoverflow.com/questions/23990690/…
Jun
2
comment In PostgreSQL is there a way to rank/weigh columns so as to order the results?
I prefer ORDER BY ... NULLS LAST over an "implicit" sort.
May
23
comment Where to put login.sql in Windows environment to configure SQL Plus?
@AaronBertrand: to be honest: that link shows up as the first or second when searching for it. It's hard to believe someone can't find it by himself. It seems despite all popularity of Google and Co, searching for answers is a dying skill
May
23
comment Where to put login.sql in Windows environment to configure SQL Plus?
@AaronBertrand: I added a link to the Microsoft knowledge base
May
23
comment How can I minimize the risk of accidentally modifying the wrong database?
My SQL tool (not SSMS) allows me to turn on a "read only mode" which simply rejects any statement that could potentially change the database.
May
22
comment Using EXECUTE IMMEDIATE inside PL\SQL Block
Cross post: stackoverflow.com/questions/23803601/…
May
22
comment Using EXECUTE IMMEDIATE inside PL\SQL Block
Any DDL statement will commit a pending transaction regardless whether the DDL is successful or not. Oracle does not support transactional DDL.