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

Jan
20
awarded  Notable Question
Oct
2
awarded  Popular Question
Feb
26
awarded  Popular Question
Sep
9
awarded  Popular Question
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.
Jun
8
awarded  Editor
Jun
8
revised What is the best way to automatically create a snapshot of the table at the certain time?
added 226 characters in body; added 117 characters in body
Jun
8
asked What is the best way to automatically create a snapshot of the table at the certain time?
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
accepted Table-name.column-name in PostgreSQL?
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
26
accepted Are there any good tools for monitoring postgresql databases
May
26
asked Table-name.column-name in PostgreSQL?
May
18
awarded  Scholar
May
18
accepted Passing an array or record to a stored procedure in PostgreSQL
May
18
awarded  Supporter