12,570 reputation
12048
bio website
location Munich
age
visits member for 3 years, 6 months
seen 2 hours ago

3h
comment Increase performance WITHOUT adding indexes
I wouldn't call statements "which are only performed every few seconds" rare. The are executed often enough to warrant an index. I have never seen a DBMS where adding an index would make the statement slower because parsing (the step where the best index is searched for) became an issue. When it comes to performance don't just assume things. Test them. Your concern about the DML is a valid one though, but I have seen only a few systems where adding an index really made the DML so bad that it had to be removed. But again: you have to test this.
3h
revised Increase performance WITHOUT adding indexes
edited tags
3h
comment How long to learn PostgreSQL?
"Entirely removing Postgres can be a bit tricky" - to "play" around I usually only unzip the archives (e.g. the zip on Windows) and run initdb manually. To "throw away" such an installation, all I need to do is to delete the directory where I unzipped the archive.
9h
revised how to define trigger scope variable
edited tags
16h
comment Error on DDL statement never invokes CATCH
"I understand that DDL statements are implicit COMMIT" - I think you are confusing Oracle (or MySQL) and SQL Server.
18h
comment How long to learn PostgreSQL?
Make sure you take the time to go through the manual, at least the chapter "SQL Language": postgresql.org/docs/current/static/sql.html
1d
comment How to restrict access to current user record and its rights in postgres
"Is it possible and reasonable to create plpgsql methods for those operations" - yes, that is possible and probably a bit safer than using a view.
1d
answered SQL MAX function
2d
revised Time series and gap filling
edited tags; edited tags
2d
revised check numeric column for empty cells
added 4 characters in body
2d
answered check numeric column for empty cells
2d
comment how to select from two tables
You are looking for a JOIN
2d
revised how to select from two tables
added 64 characters in body; edited tags
2d
revised How do I show all records related to a user?
edited tags
2d
revised What's wrong with my SQL statement?
edited tags
2d
comment Prevent Primary Key increment when an INSERT statement fail in PostgreSQL
You can't prevent. That's the whole point of using sequences. And you don't have to care either. The generated id is just some artificial value that has no meaning whatsoever. Whether your artificial key is 1, 42, 36387 or 43873483 is completely irrelevant as long as it is unique.
Nov
21
comment postgres materialized views and indexes to improve aggregate performance
Oracle actually does this. When the optimizer sees a query that matches a MVIEW query, it will use the mview instead if that is cheaper (called "query rewrite")
Nov
20
comment Error importing postgres DB dump into empty database
You might want to first try an up-to-date version. 8.4 is no longer maintained. You didn't mention your exact 8.4 version, but did you check the latest patch version for 8.4?
Nov
20
revised Error importing postgres DB dump into empty database
added 10 characters in body
Nov
19
comment PL/SQL IDE like C++ compilers
What's wrong SQL Developer?