Tour
About Us
Meta
Loading…
current community
Stack Exchange
chat
Meta Stack Exchange
your communities
Sign up
or
log in
to customize your list.
more stack exchange communities
company blog
Log in
Stack Exchange
All Sites
Top Users
Digests
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
next
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
next
Stack Exchange works best with JavaScript enabled