Roman Tkachuk's user avatar
Roman Tkachuk's user avatar
Roman Tkachuk's user avatar
Roman Tkachuk
  • Member for 7 years, 2 months
  • Last seen this week
  • Ternopil, Ukraine
6 votes

Delete an object from within an array using JSONB in PostgreSQL

4 votes
Accepted

Temporal tables extension error with array columns

4 votes

PostgreSQL IN operator with lots of values in an external file

3 votes

Lock or disable connections to Postgres while performing maintenance

3 votes

Reset Running Total based on another column

2 votes

How to select records by nth minimum/maximum value of date column in postgresql?

2 votes
Accepted

Speed up query calculation. Where can I add indexes or optimize the query or server?

2 votes
Accepted

PostgreSQL: windowing to replace multiple sub-queries ... hopefully

2 votes
Accepted

Need to export table into 2 columns, one repeating, one with rest stacked

2 votes

I have a query on two big tables that is too slow!

2 votes
Accepted

How use cascade delete for array field in PostgreSQL?

1 vote

Multicolumn indexes and OR clause

1 vote

How do I cast varchar to macaddr without changing client code

1 vote

Postgres Replication

0 votes

How to aggregate transactional records by month year but based on subscription period not calendar months?

0 votes
Accepted

postgres 9.3. resets log_min_duration_statement after receiving SIGHUP

0 votes

Convert UTC time to local time with specific format in Redshift

0 votes

Historicizing of database models

0 votes

How to properly monitor the number of PostgreSQL database connections?

0 votes

How to change PostgreSQL IP address for streaming replication

0 votes

Execution time of triggers fired when a procedure is executed in postgresql

0 votes

procedure for postgres to create table if not exist

0 votes

Can I compress two rows with a difference in two columns into a single row with both columns?

0 votes

Independent aggregation of related entities, while also sorting by related (in a single statement)

0 votes

How to conditionally recreate indexes created by `CREATE INDEX ON <table_name> (<column_name>)`?