22,215 reputation
13269
bio website
location Vienna, Austria
age 94
visits member for 3 years, 1 month
seen yesterday

1d
revised Insert New Foreign Key Row for new Strings
race condition, add links
1d
revised PostgreSQL 9.2: vacuum returning disk space to operating system
emphasize pg_repack
1d
revised Insert New Foreign Key Row for new Strings
edited tags
1d
answered Insert New Foreign Key Row for new Strings
1d
revised How do I insert a row which contains a foreign key?
trim noise, clean up
1d
comment Insert New Foreign Key Row for new Strings
"Obviously"? It seems to be the other way round: new_data.someval is a foreign key on new_data_someval_ref.someval. To avoid such ambiguities, it is always better to provide complete CREATE TABLE scripts.
1d
revised Insert New Foreign Key Row for new Strings
fix format, trim noise
2d
revised Partial db dump/restore
add tag, typos, format, trim noise.
2d
revised Partial db dump/restore
typo
Oct
27
revised Partial db dump/restore
typo
Oct
27
answered Partial db dump/restore
Oct
27
awarded  Nice Answer
Oct
24
answered Array column vs another table when the relationship is quite small
Oct
24
comment Get seconds of day in Postgres
@TimoteoPonce: Possible with a single extract() call. I added an answer.
Oct
24
answered Get seconds of day in Postgres
Oct
24
answered Slow Query with LIMIT
Oct
24
comment Slow Query with LIMIT
Key to understanding are the respective query plans. Run EXPLAIN ANALYZE post the output on explain.depesz.com and add the links to your question. You'll see different plans for the two queries.
Oct
24
revised Slow Query with LIMIT
change tags, format code, trim noise
Oct
22
revised Use GIN to index bit strings
edited tags
Oct
22
revised Use GIN to index bit strings
clarify, add links