filiprem's user avatar
filiprem's user avatar
filiprem's user avatar
filiprem
  • Member for 12 years, 6 months
  • Last seen more than a week ago
355 votes
Accepted

Force drop db while others may be connected

25 votes
Accepted

Is there a simple way in PL/pgSQL to check if a query returned no result?

24 votes

How many queries per second is my Postgres executing?

14 votes
Accepted

PostgreSQL: Query for location of global tablespace?

11 votes
Accepted

Complex view becomes slow when adding ORDER BY in outer query with small LIMIT

9 votes
Accepted

Does my choice of pg_dump format impact restore speed?

8 votes

Postgres plpgsql - Using a variable inside of a dynamic create statement

8 votes
Accepted

PostgreSQL Database Data File Integrity Check

7 votes
Accepted

How can the concatenatation of a text and a NULL value return a non-null result?

6 votes

Good, Bad or Indifferent: WHERE 1=1

6 votes
Accepted

Postgres pg_basebackup reports directory exists but is not empty

6 votes

Postgres long autovacuum halting database

4 votes
Accepted

PostgreSQL pl/perl trigger, differentiate null vs empty

4 votes
Accepted

Separate Schemas by Industry or by Application functionality?

4 votes

How to design a graph database in this scenario?

3 votes
Accepted

How filter Not NULL rows after multiple LEFT JOIN?

3 votes

Maximum number subscribers node in PostgreSQL logical replication?

3 votes
Accepted

Different execution times running a query

3 votes

How to handle schema changes in source systems when running an ETL?

3 votes
Accepted

Can't accept pgbouncer 6432 port on PostgreSQL server

3 votes

Postgresql 9.0 adding new database to streaming replication

3 votes

Can we use old primary to sync with standby after failover in PostgreSQL?

3 votes

Connect to PgAdmin III via localhost

3 votes

Reverse Byte-Order of a postgres bytea field

2 votes
Accepted

Postgres: Database architecture and materialized views

2 votes

Database agnostic auditing

2 votes

Is there an easy way in PostgreSQL to escape newlines, carriage returns, and tabs?

2 votes

How does postgres store array values?

2 votes

Does leaving a connection open for a matter of seconds cause deadlocks?

2 votes

Limiting read access in postgres to few rows