User stUrb

41 votes

1 answer

37k views

Need for indexes on foreign keys

asked Nov 22, 2013 at 16:54

7 votes

1 answer

721 views

ST_GeomFromGeoJSON() Causes postgres to crash

asked Nov 21, 2014 at 10:37

5 votes

2 answers

6k views

Group by range of years

asked Dec 16, 2014 at 9:11

5 votes

1 answer

17k views

group by and display contents of last row for each result

asked Apr 30, 2014 at 16:29

1 vote

1 answer

2k views

Correct pg_hba.conf to allow script to run locally with a specific db-user

asked Nov 28, 2013 at 19:36

1 vote

1 answer

842 views

Best approach on storing/displaying sanitized data

asked Mar 6, 2014 at 12:19

1 vote

1 answer

876 views

Migrate SQL Server binary datadump to postgresql

asked Dec 12, 2014 at 8:40

1 vote

0 answers

151 views

using separate schemas or databases

asked Oct 25, 2013 at 15:46

1 vote

3 answers

6k views

Including rows from base table with left joins when these joins are 'empty'

asked Jan 19, 2017 at 10:05

0 votes

0 answers

637 views

Slow query over 10mil rows with group by on indexed column

asked Apr 2, 2015 at 12:08

0 votes

1 answer

181 views

Storing not very volatile information in database with cache or mongodb

asked Sep 22, 2014 at 13:29

Stack Exchange Network

11 Questions

Need for indexes on foreign keys

ST_GeomFromGeoJSON() Causes postgres to crash

Group by range of years

group by and display contents of last row for each result

Correct pg_hba.conf to allow script to run locally with a specific db-user

Best approach on storing/displaying sanitized data

Migrate SQL Server binary datadump to postgresql

using separate schemas or databases

Including rows from base table with left joins when these joins are 'empty'

Slow query over 10mil rows with group by on indexed column

Storing not very volatile information in database with cache or mongodb