191 reputation
310
bio website
location
age
visits member for 3 years, 7 months
seen Nov 22 at 13:13

Nov
18
comment Best design to handle multiple query keys
OK, I go suggested way. Thank you everybody for your input.
Nov
6
comment Best design to handle multiple query keys
One table - this is requirements that I cannot change.
Nov
6
comment Best design to handle multiple query keys
@dezso If it is not "classical" approach that we all used to stick with it doesn't mean it will result with awful performance.
Nov
6
comment Best design to handle multiple query keys
Solution from Michael is a classic one. You can find it in any book. But I doubt it will work well on the huge data.
Nov
6
comment Best design to handle multiple query keys
@ypercube for me that mean that you don't have experience with problems I mentioned. I DO KNOW about technique you described, but it doesn't work well on fast growing data. This is why I asked about other approach. Let's stop off-topic discussion and stick to the subject. I need a tip for the person who knows the problem. This is not question for guys that just know PostgreSql or have some ex with it. I know that other company does it with one table and it works very fast.
Nov
6
comment Best design to handle multiple query keys
@ypercube Guys, if you have nothing to say on the topic please pass by. I am really not forcing you to reply. This is not an exam. No answer - no need for reply. Thank you for understanding.
Nov
6
comment Best design to handle multiple query keys
@dezso As I mentioned in the question, I want to have only one table, so, there is no place for "normalization" in my opinion. By using "normalization" I would expect to have several tables with references by ids. So, could you please clarify what do you mean by "normalization", so your reply will be useful for me and for community?
Nov
6
comment Best design to handle multiple query keys
@ErwinBrandstetter I just added typical query. Further sorting is not relevant - I can do it in another subquery - my main question is - how to organize selection by Player-Id without extra tables. Thank you for your attention.
Nov
6
comment Best design to handle multiple query keys
@dezso Lets see what other say. I think PostgreSQL is a right platform, I just have to find a proper way to do it. I am sure there is a good technique for my task.
Nov
6
comment Best design to handle multiple query keys
@ErwinBrandstetter, I added that player might be interested in most in last XXX of his games. Sorting and form of the data is not subject of my question.
Nov
6
comment Best design to handle multiple query keys
Normalization won't work for me. If you are interested, please see accepted question on SO. I will try to go with like.
Nov
5
comment Best design to handle multiple query keys
Each key corresponds to a json_data. There is no such a think as a key combination. Every time it can be any keys.
Jun
8
comment What is the best way to automatically create a snapshot of the table at the certain time?
No, I am not indexing data. It is just transactions, so - no need for index in there.
Jun
8
comment What is the best way to automatically create a snapshot of the table at the certain time?
Thank for suggestion. Won't work for me - my DB serves people all over the World. They work with my app from home too. So I cannot rely on "everyones drinks beer". I think idea with triggers I wrote about will work for me.
Jun
8
comment What is the best way to automatically create a snapshot of the table at the certain time?
I use 9.0.4. But as far as I understood hot-standby is more for recovery cases and not for snapshotting. I need robust snapshoting solution.
May
29
comment Table-name.column-name in PostgreSQL?
Seems that Navicat is not about acepting client's feedback: navicat.com/en/support/support_ticket/submit_ticket.html
May
29
comment Table-name.column-name in PostgreSQL?
Hi Jack, for sure. I just have to fid out how I submit a new ticket for them :-)
May
26
comment Table-name.column-name in PostgreSQL?
Thank you for your reference. Now I can say: Now I know for sure!
May
26
comment Table-name.column-name in PostgreSQL?
I see the trick you've suggested. Very nice, but how it may influence overall perfomance? Anyway, I asked this question because I just started to use Navicat app for working with PostgreSQL from my Mac. So, in Navicat code autocompletion works properly with table-name.column-name way... Strange thing indeed.
May
18
comment Are there any good tools for monitoring postgresql databases
Yes, mostly OLTP and some stats calculation. It will be a backend for online game for social networks with some capitalism in it.