User Luciano Andress Martini

10 votes

Accepted

Estimate end time for a long update

answered Sep 19, 2018 at 18:30

7 votes

Create INSERT INTO from SELECT in PostgreSQL

answered Apr 15, 2016 at 19:23

4 votes

Disallowing table creation in the public schema

answered Sep 20, 2018 at 13:18

3 votes

Accepted

PostgreSQL 9.1 and 9.4 faster than 9.6

answered May 5, 2017 at 14:45

3 votes

Accepted

In what order does PostgreSQL check object permissions?

answered Mar 15, 2018 at 12:18

3 votes

Accepted

How can I create a join on three tables, each from a different database?

answered Apr 15, 2016 at 18:24

3 votes

Slow Bitmap Heap Scan, Order by killing the execution time

answered Oct 2, 2018 at 16:35

3 votes

Accepted

What is included in ALL permissions for functions in PostgreSQL?

answered Oct 3, 2018 at 12:14

2 votes

Running a psql command inside a Postgres function

answered Sep 28, 2018 at 18:29

2 votes

Postgres 9.3 - deletes terribly slow for 10 minutes after dropping indexes/constraints

answered May 13, 2015 at 13:54

2 votes

Accepted

Overcome Runtime error when exporting large data table from PostgreSQL

answered Sep 25, 2018 at 12:28

1 vote

How open oracle DB Linux (After installation)

answered May 14, 2015 at 14:40

1 vote

MySQL workbench: Cannot Connect to Database Server (ssh)

answered May 14, 2015 at 15:05

1 vote

PostgreSQL 8.4 replication of more than 100 tables

answered Jun 24, 2015 at 13:58

1 vote

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3

answered Jul 15, 2015 at 19:37

1 vote

Random unguessable primary key which preserves correct order

answered Mar 28, 2016 at 12:36

1 vote

Error launching sqlplus

answered Apr 19, 2016 at 11:47

1 vote

How do I install a PostgreSQL extension in Windows?

answered Sep 26, 2018 at 15:22

1 vote

Accepted

COPY query with variable path

answered Oct 2, 2018 at 13:41

0 votes

SELECT operation with four joins results in bad performance

answered Oct 1, 2018 at 19:34

0 votes

For each value in field A, select the row with some special value in field B, while respecting further criteria

answered Oct 1, 2018 at 20:19

0 votes

PgAdmin4 unusable when database has lots of schemas

answered Dec 6, 2018 at 11:46

0 votes

Incomplete installation with unsupported locale

answered Apr 19, 2016 at 12:20

0 votes

One connection vs multi connection

answered Mar 28, 2016 at 12:26

0 votes

count distinct number of records in sql

answered Sep 25, 2018 at 20:33

0 votes

Separating Numeric Values from string

answered Sep 25, 2018 at 20:57

0 votes

SUM value in table with timestamp column where timestamp is between start and stop timestamps in different table

answered Sep 20, 2018 at 13:39

0 votes

How to delete records without a primary key in a stardard way (i.e. not using ctid)

answered Sep 21, 2018 at 18:50

0 votes

Filter results based on data from another table

answered Sep 21, 2018 at 19:41

Stack Exchange Network

29 Answers

Estimate end time for a long update

Create INSERT INTO from SELECT in PostgreSQL

Disallowing table creation in the public schema

PostgreSQL 9.1 and 9.4 faster than 9.6

In what order does PostgreSQL check object permissions?

How can I create a join on three tables, each from a different database?

Slow Bitmap Heap Scan, Order by killing the execution time

What is included in ALL permissions for functions in PostgreSQL?

Running a psql command inside a Postgres function

Postgres 9.3 - deletes terribly slow for 10 minutes after dropping indexes/constraints

Overcome Runtime error when exporting large data table from PostgreSQL

How open oracle DB Linux (After installation)

MySQL workbench: Cannot Connect to Database Server (ssh)

PostgreSQL 8.4 replication of more than 100 tables

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3

Random unguessable primary key which preserves correct order

Error launching sqlplus

How do I install a PostgreSQL extension in Windows?

COPY query with variable path

SELECT operation with four joins results in bad performance

For each value in field A, select the row with some special value in field B, while respecting further criteria

PgAdmin4 unusable when database has lots of schemas

Incomplete installation with unsupported locale

One connection vs multi connection

count distinct number of records in sql

Separating Numeric Values from string

SUM value in table with timestamp column where timestamp is between start and stop timestamps in different table

How to delete records without a primary key in a stardard way (i.e. not using ctid)

Filter results based on data from another table