Erwin Brandstetter

less info
meta site favicon meta user | stack exchange network profile network profile
8,896 reputation
1238
bio website
location Vienna, Austria
age 93
visits member for 1 year, 7 months
seen 3 hours ago
stats profile views 349

212 Answers

newest activity votes
5
PostgreSQL 8.4: How to tell if a procedural language is installed or not?
5
Multicolumn index and performance
5
Slow query on large table with GROUP BY and ORDER BY
5
Many-to-Too-Many Relationship
5
Measure the size of a PostgreSQL table row
5
Should I use the PostgreSQL bit string?
5
What can I do with the new json field?
5
How to check if a subquery has exactly one distinct result and a specified value concisely?
5
How do I list all columns for a specified table
5
How to run specific version (8.4, 9.1) of postgresql pg_* command (e.g., pg_dump)
5
Slow ORDER BY with LIMIT
5
Help with this SELECT in the same table
5
What is the meaning of n_live_tup and n_dead_tup in pg_stat_user_tables
5
postgresql view with max min with id
4
Postgresql function to create table
4
“Truncate” or “Delete/Vacuum Full” for deleting some of the table rows
4
Select first row (grouping) + add aggregate function
4
Optimizing bulk update performance in Postgresql
4
How to access the number of rows accumulated by RETURNs in PL/pgSQL
4
PostgreSQL 9.2: vacuum returning disk space to operating system
4
Find “n” consecutive free numbers from table
4
How do I remove duplicate records in a join table in PostgreSQL?
4
Select longest continuous sequence
4
Why did PostgreSQL choose an elephant as it's logo?
4
Aggregating statistics from child rows
4
Something wrong in pg_hba.conf
4
Is there a way to avoid duplicating the definition of a foreign key?
4
Query optimization or missing indexes?
4
Using a Select in a Where clause for another Select
4
Performance of different precedence pseudocolumn solutions with LIMIT
1 2 3 4 5 … 8