Stack Exchange

Erwin Brandstetter

Vienna, Austria

Database expert.

top accounts reputation activity bookmarks subscriptions
Top Questions
39 votes

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: <!-​- language: lang-none --> 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

PostgreSQL functions returning void

postgresql stored-procedures null plpgsql void asked Nov 30, 2011 at 1:15
stackoverflow.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

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

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

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

12 votes

Inconsistencies in the rendering of lists

bug status-completed markdown markdown-rendering asked Nov 4, 2014 at 1:39
meta.stackexchange.com

12 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

1 2 3 4

Top Answers
1518
Select first row in each GROUP BY group?
stackoverflow.com

1077
Insert text with single quotes in PostgreSQL
stackoverflow.com

978
PostgreSQL error: Fatal: role "username" does not exist
stackoverflow.com

521
Select rows which are not present in other table
stackoverflow.com

482
Create unique constraint with null columns
stackoverflow.com

412
PostgreSQL Crosstab Query
stackoverflow.com

411
Best way to check for "empty or null value"
stackoverflow.com

404
PostgreSQL create table if not exists
stackoverflow.com

402
Check if value exists in Postgres array
stackoverflow.com

398
Are PostgreSQL column names case-sensitive?
stackoverflow.com

392
Fast way to discover the row count of a table in PostgreSQL
stackoverflow.com

392
How to implement a many-to-many relationship in PostgreSQL?
stackoverflow.com

383
How do I (or can I) SELECT DISTINCT on multiple columns?
stackoverflow.com

379
PostgreSQL: Give all permissions to a user on a PostgreSQL database
stackoverflow.com

371
Ignoring time zones altogether in Rails and PostgreSQL
stackoverflow.com

365
How to check if a table exists in a given schema
stackoverflow.com

344
How to use RETURNING with ON CONFLICT in PostgreSQL?
stackoverflow.com

337
PostgreSQL LIKE query performance variations
stackoverflow.com

331
Concatenate multiple result rows of one column into one, group by another column
stackoverflow.com

314
How to concatenate columns in a Postgres SELECT?
stackoverflow.com

309
Query for array elements inside JSON type
stackoverflow.com

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

304
IN vs ANY operator in PostgreSQL
stackoverflow.com

295
Best way to select random rows PostgreSQL
stackoverflow.com

267
Run a query with a LIMIT/OFFSET and also get the total number of rows
stackoverflow.com

261
What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
stackoverflow.com

261
Postgres manually alter sequence
stackoverflow.com

260
Does PostgreSQL support "accent insensitive" collations?
stackoverflow.com

242
Calculating and saving space in PostgreSQL
stackoverflow.com

237
Optimizing queries on a range of timestamps (two columns)
dba.stackexchange.com

1 2 3 4 5 … 10