User arthur

10 votes

1 answer

9k views

Estimating the size (of the records) and the overhead in Postgres

asked Jun 23, 2015 at 11:27

8 votes

1 answer

10k views

Automatic conversion of anonymous records returned from an UDF to well known table-type

asked Nov 5, 2013 at 17:13

7 votes

1 answer

468 views

UUID V1 and V4 bloats substantially after sequntial inserts and deletes. Why is it so, compared to serial and temporal BTree (which does not bloat)?

asked Jan 3, 2018 at 12:26

5 votes

2 answers

19k views

Escaping delimiter in postgresql

asked Sep 17, 2014 at 9:14

4 votes

1 answer

1k views

Persistent inserts in a UDF even if the function aborts

asked Jun 24, 2015 at 11:44

3 votes

4 answers

29k views

Insert values from a record variable into a table

asked Nov 5, 2013 at 16:04

3 votes

2 answers

2k views

Table size without indexes in sql server

asked Jan 29, 2021 at 9:31

3 votes

1 answer

384 views

Request Sch-M lock on a table

asked Apr 30, 2021 at 7:54

2 votes

2 answers

7k views

Restoring the superuser account on the postgres server

asked Mar 26, 2014 at 10:17

2 votes

1 answer

810 views

getting the output of delete statement in UDF in postgres

asked Sep 18, 2013 at 11:37

2 votes

0 answers

553 views

Primary key violation

asked May 9, 2018 at 14:42

2 votes

0 answers

687 views

Bulk Updates (inserts, update) and check constraints

asked Jun 19, 2018 at 8:18

1 vote

0 answers

1k views

What makes ALTER TABLE X SET UNLOGGED; to be slow?

asked Jan 18, 2019 at 11:40

1 vote

0 answers

42 views

Impact of numerous indexes on query optimizer for a delete statement

asked May 16, 2018 at 11:44

1 vote

1 answer

647 views

Why select statement requests exclusive locks?

asked May 7, 2018 at 13:16

1 vote

2 answers

3k views

calling a function with parameters in insert

asked Dec 9, 2013 at 16:47

1 vote

1 answer

654 views

Numbering rows consecutively for a number of tables

asked Dec 13, 2013 at 12:31

1 vote

1 answer

10k views

Specify the account in domain format Error in SQL Server 2016 installation on Windows 10

asked Oct 24, 2017 at 11:45

1 vote

2 answers

797 views

ACID violation in Postgres 9.1?

asked Oct 21, 2014 at 9:46

1 vote

0 answers

669 views

pg_repack binaries under windows

asked Aug 26, 2020 at 4:50

0 votes

2 answers

43 views

UDF in MS SQL Server returning a query starting with "with" cause

asked Jan 19, 2021 at 9:14

0 votes

1 answer

620 views

Tracking (un)successful autovacuums in postgres

asked Feb 18, 2021 at 12:07

0 votes

1 answer

373 views

Memory Optimized Azure Postgres

asked May 2, 2021 at 9:14

0 votes

0 answers

74 views

Full Text Search Launcher service and process

asked Sep 13, 2021 at 10:41

0 votes

0 answers

296 views

db backup fail, cannot allocate memory

asked Dec 7, 2021 at 15:58

0 votes

2 answers

3k views

Restarting hot_standby replication when the slave fails

asked May 8, 2018 at 16:03

0 votes

0 answers

232 views

How to check if a string contains a sequence of binary regexp chars in postgres

asked Feb 12, 2020 at 16:54

0 votes

0 answers

566 views

to_json vs ::json in postgres

asked Jul 1, 2020 at 8:53

0 votes

1 answer

176 views

adding pgadmin3 to windows start menu

asked Dec 26, 2018 at 20:34

Stack Exchange Network

29 Questions

Estimating the size (of the records) and the overhead in Postgres

Automatic conversion of anonymous records returned from an UDF to well known table-type

UUID V1 and V4 bloats substantially after sequntial inserts and deletes. Why is it so, compared to serial and temporal BTree (which does not bloat)?

Escaping delimiter in postgresql

Persistent inserts in a UDF even if the function aborts

Insert values from a record variable into a table

Table size without indexes in sql server

Request Sch-M lock on a table

Restoring the superuser account on the postgres server

getting the output of delete statement in UDF in postgres

Primary key violation

Bulk Updates (inserts, update) and check constraints

What makes ALTER TABLE X SET UNLOGGED; to be slow?

Impact of numerous indexes on query optimizer for a delete statement

Why select statement requests exclusive locks?

calling a function with parameters in insert

Numbering rows consecutively for a number of tables

Specify the account in domain format Error in SQL Server 2016 installation on Windows 10

ACID violation in Postgres 9.1?

pg_repack binaries under windows

UDF in MS SQL Server returning a query starting with "with" cause

Tracking (un)successful autovacuums in postgres

Memory Optimized Azure Postgres

Full Text Search Launcher service and process

db backup fail, cannot allocate memory

Restarting hot_standby replication when the slave fails

How to check if a string contains a sequence of binary regexp chars in postgres

to_json vs ::json in postgres

adding pgadmin3 to windows start menu