a_horse_with_no_name

8,125 reputation

11027

bio	website
	location	Munich
	age
visits	member for	2 years
	seen	9 hours ago
stats	profile views	727

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

	8,125 reputation	bio	website		visits	member for	2 years
11027 badges		location	Munich		seen	9 hours ago

summary answers questions tags badges favorites bounties reputation activity

1,298 Actions

suggestions reviews revisions comments badges posts accepts all

15h	comment	How to store many smallish time-series in a relational DB? I think this could be stored quite efficiently in Postgres using the `hstore` datatype ("NoSQL" like key/value type) or an array but that is obviously not an option. I think having one table for the values is probably going to be the most maintainable solution. You probably want to partition that table by `measurement_id`
1d	revised	Exporting and importing a database edited tags
2d	comment	Inner join using an array column The equality operator in SQL is `=` not `==`
2d	comment	Inner join using an array column The equality operator in SQL is `=` not `==`
May 19	revised	Database size not reduced after compressing tables edited tags
May 19	comment	Make rows immutable allow Insert mysql5 Cross posted: stackoverflow.com/questions/16634741
May 19	revised	Query for Oracle database added 30 characters in body
May 19	revised	What happen when Postgresql tablespace is null? improved formatting
May 18	revised	oracle database query improved formatting
May 18	revised	change data directory postgres with database cluster deleted 15 characters in body
May 18	comment	How to make continues cluster? How can the table have 30 million rows in total yet have 20 million per month? Are only storing one and a half months in there?
May 18	comment	How to make continues cluster? Sounds more like a use case for partitioning rather than the `cluster` comand.
May 17	revised	When to split a large table edited body; edited tags
May 17	revised	Can't use SQL Server database on a networkpath added 14 characters in body
May 17	comment	Can't use SQL Server database on a networkpath Which DBMS are you using? Postgres? Oracle? Microsoft? (`SQL` is just a query language, every RDBMS is a "SQL database")
May 17	awarded	Yearling
May 16	answered	How un-clustered is a CLUSTER USING table
May 16	revised	How to get the information of the optimizer of PostgreSQL? added 1 characters in body
May 16	comment	Is there a fast way to change column type without dropping the clustered index? How do you know it will improve performance? I doubt that you can really measure the difference.
May 16	comment	Performance Hit when upgrading to Oracle 11gr2 Seems to be, 11gR2 is twice as fast: it only needs half of the consistent gets. The number of physical reads simply means the data wasn't (yet) cached. What happened when you immediately ran the same statement again?