User Zeruno - Database Administrators Stack Exchange

Zeruno

Member for 7 years
Last seen more than a month ago

Network profile

13 Questions

Score Activity Newest Views

19 votes

1 answer

2k views

What exactly is the 'online' in OLAP and OLTP?

asked Jun 19, 2019 at 12:03

4 votes

2 answers

23k views

Using Postgres COPY TO for data export without overwriting file

asked Mar 13, 2017 at 23:14

4 votes

1 answer

2k views

Does PostgreSQL/PostGIS use R-Tree or R*-Tree?

asked Apr 29, 2017 at 19:01

3 votes

0 answers

1k views

When does the PostgreSQL 12 CTE materialized option provide an optimization advantage?

asked Mar 18, 2020 at 9:10

3 votes

2 answers

3k views

Is PostgreSQL function parallel safety intended for functions which update data?

asked Mar 20, 2020 at 3:35

2 votes

1 answer

555 views

Stop rollback of anonymous DO code block?

asked Mar 21, 2020 at 17:23

1 vote

1 answer

76 views

How can we foresee (and configure) B-Tree and R-Tree indexes width and depth in PostgreSQL? [closed]

asked Feb 4, 2018 at 23:09

0 votes

1 answer

294 views

SQL to MDX translation?

asked Apr 17, 2019 at 1:22

0 votes

1 answer

137 views

PostgreSQL CREATE TYPE using multiple relations?

asked Jul 5, 2019 at 16:48

0 votes

1 answer

67 views

Building and Executing a Query Execution Plan Manually in PostgreSQL

asked Jul 5, 2019 at 17:27

0 votes

1 answer

41 views

Enforcing lowest transaction isolation level across concurrent sessions?

asked Mar 17, 2020 at 19:25

0 votes

0 answers

1k views

Dynamically creating a new table from a given table name without return type using a PostgreSQL function?

asked Mar 21, 2020 at 4:21

0 votes

1 answer

128 views

Reducing CREATE TABLE overhead?

asked Mar 18, 2020 at 11:43