10,382 reputation
11336
bio website
location Munich
age
visits member for 2 years, 11 months
seen 6 hours ago

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


9h
comment What are suitable databases for GIS data for MapInfo and ArcGIS and WindPro?
My understanding is that Postgres + PostGIS is currently a very good choice (OpenStreetmap completely migrated to that)
1d
comment Postgresql JDBC Table Valued Parameters
You insert into it and then you select from it. There is nothing special about using a temp table (apart from the fact that the rows automatically go away). Any decent JDBC tutorial will have examples for inserting and reading from a table.
1d
comment Postgres: Estimate of server specs required for write-heavy load?
Additionally: that link is over 8 years old, not sure how much of that is still valid.
1d
comment Postgresql JDBC Table Valued Parameters
Why don't you use a temporary table?
1d
comment Postgresql JDBC Table Valued Parameters
Cross posted: stackoverflow.com/questions/23008966
1d
comment Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL column
Any triggers on the table?
1d
comment Mirroring error #1418
Writing ALL UPPERCASE is considered SHOUTING and rude
2d
comment MS SQL Server Implement Limit Functionality
The equivalent to limit would be top in SQL Server
Apr
17
comment DISTINCT not using an index
explain plan for select ...; select * from table(dbms_xplan.display);
Apr
17
comment DISTINCT not using an index
Well if the column is nullable the index cannot be used as tuples consisting completely of null values won't make it into the index. You can trick Oracle to index them nonetheless using an index defined as (column4, 1). Btw: why don't you just copy and paste the text result of an explain. That is usually much easier to read than an image or some other obfuscated output.
Apr
17
comment DISTINCT not using an index
Is the column nullable? And what does the execution plan say?
Apr
16
comment ORA-30009: Not enough memory for CONNECT BY operation
None of those tips will reduce the memory required by a connect by query.
Apr
16
comment ORA-30009: Not enough memory for CONNECT BY operation
Please show us the query and the execution plan.
Apr
16
comment PostgreSQL DB size increasing after restoring the same database backup
A pg_restore will only delete data if you use the --clean switch. I'm surprised you didn't get a bunch of errors when you tried to restore the data into the same database.
Apr
16
comment PostgreSQL DB size increasing after restoring the same database backup
You are not dropping the old DB or at least the old tables. If your tables don't have a primary or unique key (which would be very bad) then I guess it's possible that a restore into the same DB will just add the rows from the backup
Apr
16
comment Can comments in stored procedures cause problems
I have seen situations where such comments caused trouble (it's been a while, can't recall the exact circumstances). After using block comments /* ... */ instead of line comment things were OK.
Apr
15
comment postgresql being slow on count distinct for dates
wiki.postgresql.org/wiki/Slow_Query_Questions
Apr
15
comment Get first login-Hit on huge table
What's unclear about the error message?
Apr
15
comment Get first login-Hit on huge table
Which DBMS are you using? Postgres? Oracle? How does the execution plan look like?
Apr
15
comment How slow is slow in postgres?
hash indexes are pretty much "discouraged" - you are probably better off using a b-tree index instead. Plus, if you have many NULL values in your table using a partial index on group_a IS NOT NULL might help considerably. Adding a to the index definition might help with the group by. With such a big table you almost certainly want to increase work_mem drastically