Skip to main content
Tour
About Us
Meta
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 400 Users
Digests
Erwin Brandstetter
Vienna, Austria
Database expert.
top
accounts
reputation
activity
subscriptions
Top Questions
40
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
30
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
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
15
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
13
votes
Can declaring function volatility IMMUTABLE harm performance?
postgresql
performance
postgresql-performance
functions
asked Jul 13, 2018 at 23:43
dba.stackexchange.com
1
2
3
4
next
Top Answers
1800
Select first row in each GROUP BY group?
stackoverflow.com
1304
Insert text with single quotes in PostgreSQL
stackoverflow.com
1078
PostgreSQL error: Fatal: role "username" does not exist
stackoverflow.com
667
Create unique constraint with null columns
stackoverflow.com
602
Select rows which are not present in other table
stackoverflow.com
567
Fast way to discover the row count of a table in PostgreSQL
stackoverflow.com
517
Best way to check for "empty or null value"
stackoverflow.com
495
Are PostgreSQL column names case-sensitive?
stackoverflow.com
480
PostgreSQL create table if not exists
stackoverflow.com
475
PostgreSQL: Give all permissions to a user on a PostgreSQL database
stackoverflow.com
474
Check if value exists in Postgres array
stackoverflow.com
459
PostgreSQL Crosstab Query
stackoverflow.com
453
How to implement a many-to-many relationship in PostgreSQL?
stackoverflow.com
441
IN vs ANY operator in PostgreSQL
stackoverflow.com
432
How to use RETURNING with ON CONFLICT in PostgreSQL?
stackoverflow.com
429
How do I (or can I) SELECT DISTINCT on multiple columns?
stackoverflow.com
421
How to check if a table exists in a given schema
stackoverflow.com
414
Concatenate multiple result rows of one column into one, group by another column
stackoverflow.com
400
Ignoring time zones for Postgres timestamps
stackoverflow.com
395
PostgreSQL LIKE query performance variations
stackoverflow.com
375
What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
stackoverflow.com
368
Query a parameter (postgresql.conf setting) like "max_connections"
stackoverflow.com
360
Query for array elements inside JSON type
stackoverflow.com
358
How to concatenate columns in a Postgres SELECT?
stackoverflow.com
358
Run a query with a LIMIT/OFFSET and also get the total number of rows
stackoverflow.com
352
Best way to select random rows PostgreSQL
stackoverflow.com
317
Does PostgreSQL support "accent insensitive" collations?
stackoverflow.com
301
Postgres manually alter sequence
stackoverflow.com
291
Select first row in each GROUP BY group?
stackoverflow.com
281
Sort NULL values to the end of a table
stackoverflow.com
1
2
3
4
5
…
10
next