Erwin Brandstetter

Vienna, Austria

Database expert.

top accounts reputation activity subscriptions

USING construct in JOIN clause can introduce optimization barriers in certain cases?

postgresql performance optimization join select asked Apr 12, 2012 at 8:06

dba.stackexchange.com

28 votes

"Recheck Cond:" line in query plans with a bitmap index scan

postgresql index postgresql-9.4 query-plan asked Jul 8, 2015 at 0:25

dba.stackexchange.com

22 votes

Syntax highlighting:  does not seem to work for block quote

bug code-formatting syntax-highlighting markdown-rendering asked Sep 7, 2015 at 15:45

meta.stackexchange.com

19 votes

Naming conflict between function parameter and result of JOIN with USING clause

postgresql join plpgsql parameter naming-convention asked Jul 2, 2015 at 23:54

dba.stackexchange.com

18 votes

PostgreSQL functions returning void

postgresql stored-procedures null plpgsql void asked Nov 30, 2011 at 1:15

stackoverflow.com

15 votes

Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?

sql postgresql constraints postgresql-9.1 asked Apr 5, 2012 at 16:19

stackoverflow.com

14 votes

Why is code excluded from phrase search?

bug search exact-phrase asked May 17, 2017 at 19:27

meta.stackexchange.com

14 votes

Description page for the "Edit questions and answers" privilege needs an edit

bug status-completed stackoverflow privileges asked Oct 10, 2011 at 6:19

meta.stackexchange.com

14 votes

Why not ERROR: index row size xxxx exceeds maximum 2712 for index "foo"?

postgresql index size limits asked Sep 8, 2018 at 15:56

dba.stackexchange.com

12 votes

Surprising results for data types with type modifier

postgresql datatypes cte debugging cast asked Sep 26, 2015 at 0:36

dba.stackexchange.com

Top Answers

1713

Select first row in each GROUP BY group?

stackoverflow.com

1225

Insert text with single quotes in PostgreSQL

stackoverflow.com

1049

PostgreSQL error: Fatal: role "username" does not exist

stackoverflow.com

595

Create unique constraint with null columns

stackoverflow.com

583

Select rows which are not present in other table

stackoverflow.com

507

Fast way to discover the row count of a table in PostgreSQL

stackoverflow.com

489

Best way to check for "empty or null value"

stackoverflow.com

464

Are PostgreSQL column names case-sensitive?

stackoverflow.com

454

PostgreSQL create table if not exists

stackoverflow.com

453

Check if value exists in Postgres array

stackoverflow.com

450

PostgreSQL Crosstab Query

stackoverflow.com

438

How to implement a many-to-many relationship in PostgreSQL?

stackoverflow.com

437

PostgreSQL: Give all permissions to a user on a PostgreSQL database

stackoverflow.com

416

How do I (or can I) SELECT DISTINCT on multiple columns?

stackoverflow.com

403

How to check if a table exists in a given schema

stackoverflow.com

397

How to use RETURNING with ON CONFLICT in PostgreSQL?

stackoverflow.com

394

Concatenate multiple result rows of one column into one, group by another column

stackoverflow.com

392

Ignoring time zones altogether in Rails and PostgreSQL

stackoverflow.com

390

IN vs ANY operator in PostgreSQL

stackoverflow.com

373

PostgreSQL LIKE query performance variations

stackoverflow.com

352

Query a parameter (postgresql.conf setting) like "max_connections"

stackoverflow.com

348

How to concatenate columns in a Postgres SELECT?

stackoverflow.com

346

Query for array elements inside JSON type

stackoverflow.com

331

Best way to select random rows PostgreSQL

stackoverflow.com

331

Run a query with a LIMIT/OFFSET and also get the total number of rows

stackoverflow.com

331

What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?

stackoverflow.com

295

Does PostgreSQL support "accent insensitive" collations?

stackoverflow.com

281

Postgres manually alter sequence

stackoverflow.com

276

Select first row in each GROUP BY group?

stackoverflow.com

259

Calculating and saving space in PostgreSQL

stackoverflow.com