192 reputation
38
bio website
location
age
visits member for 3 years, 5 months
seen Jul 16 at 17:39

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.