11,197 reputation
11843
bio website
location Munich
age
visits member for 3 years, 2 months
seen 6 mins ago

Jun
25
comment Performance issue in Postgresql9.3
Unrelated but: work_mem = 30GB is way to high. The 30GB may be allocated multiple times per statement (for each sort/hash step during execution).
Jun
24
comment How list of netezza system tables/views?
If Netezza supports transactions, then there can't be such a view. If you have multiple transactions all deleting and inserting rows into a table at the same time, which row count should that view show you?
Jun
24
comment How to print ORDER wise using LEFT JOIN in SQL?
An order by in a derived table (or a sub-select) does not make any sense. You need to apply the order by to the complete query (not the derived table).
Jun
23
comment ORA-00907: missing right parenthesis on query with subqueries
Actually except is defined in the SQL standard. It's not specific to SQL Server. But apart from that, you are right. minus is Oracle's implementation of the standard except operator
Jun
23
comment Issue working with Postgres on Windows
Try the psql command on a real Windows commandline, not from within pgAdmin. Maybe pgAdmin doesn't pass the parameters correctly
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.