Reputation
11,829
Next tag badge:
686/1000 score
213/200 answers
Badges
7 32 55
Newest
 Revival
Impact
~590k people reached

Jan
29
revised Insert performance
deleted 8 characters in body; edited title
Jan
29
revised How to combine UNION and INNER JOIN?
added 51 characters in body
Jan
29
revised Ordering in postgresql
deleted 1327 characters in body
Jan
28
revised Why are correlated subqueries sometimes faster than joins in Postgres?
added 37 characters in body
Jan
27
awarded  Yearling
Jan
27
revised Cube with 2 measure groups (with different relationships to dimensions) returns too many dimension members in reports
edited body
Jan
26
comment How to improve this union to ensure consistent results?
If I understand the idea correctly, this answer might help: dba.stackexchange.com/a/123836/6219
Jan
26
comment Database: One table or many
@Shafee Daniel just gave you a rough solution, see the last paragraph. JSON is very important, and it is very useful when used right.
Jan
26
comment Maintaining SQL Server 2008 R2 on Windows 10
What does your answer add to @Shanky's?
Jan
25
revised DISTINCT ON vs ROW_NUMBER() for getting a row with a maximum value of a group
added 35 characters in body
Jan
23
comment Is there some kind of table-level replication in PostgreSQL?
Could you be slightly more specific on what 'weird' means and how it is checked?
Jan
23
revised m-to-n total participation in SQL
edited tags
Jan
22
revised PostgreSQL not using index during count(*)
added 16 characters in body; edited tags; edited title
Jan
22
comment Passing ROWTYPE parameter to EXECUTE
I know this does not answer the question, but please consider upgrading your DB - it is currently 7 versions behind.
Jan
22
revised SQL Server 2008 R2 SP1 - Tempdb “Available free space” showing negative value
deleted 18 characters in body
Jan
22
revised Extract ID String - PostgreSQL 9.2
rolled back to a previous revision
Jan
21
comment Dealing with partitioned tables in Postgresql
Again, if I understood correctly, they already jumped :) Otherwise, I agree.
Jan
21
comment Dealing with partitioned tables in Postgresql
If I understood the question correctly, they insert new data in the partitions only, therefore the big table does not change anymore. Eventually, when 90 new partitions will be filled, the big one can be truncated as you suggest. On a busy database, we have seen problems with a deletion policy in place from the beginning: the autovacuum could not really keep up. It needed much tuning to handle the workload, including tweaking the wraparound and freezing related parameters.
Jan
21
comment Foreign key for array column
@ValSt well, I got your table definition above to guess what you want. So, it's you who should know what trials is about. If you manage to describe this in English (as opposed to any programming (pseudo)language), as DeadEye asks for, it could help a lot understanding your requirements. At the same time, I'd suggest getting a good book or tutorial about relational databases and data modeling.
Jan
21
answered Foreign key for array column