User Josh Berkus

50 votes

Aggressive Autovacuum on PostgreSQL

answered Jul 28, 2012 at 20:50

12 votes

Accepted

PostgreSQL data type text vs varchar without length

answered Jul 12, 2012 at 6:41

9 votes

Accepted

How do you figure out what planner cost constants to use in Postgres?

answered Aug 3, 2012 at 2:39

7 votes

How to drop inheritance?

answered Jun 14, 2013 at 23:12

6 votes

Why do psql queries take longer when inserting many rows. Why is it non linear

answered May 2, 2013 at 3:32

5 votes

SQL Database vs Multiple Microsoft Access Databases

answered Jul 14, 2022 at 23:28

4 votes

Postgresql: Two concurrent COPY FROM

answered Jul 12, 2012 at 6:36

3 votes

How to configure postgresql to use multiple cores?

answered Jul 12, 2012 at 6:46

3 votes

Why does PostgreSQL aggregate result in the Index or Seq scan outputting all columns of the table?

answered Oct 14, 2012 at 0:45

2 votes

PostgreSQL hot standby promotion, multiple hot standbys

answered Aug 16, 2012 at 4:36

2 votes

Which performance can I expect?

answered Sep 30, 2012 at 0:31

2 votes

Accepted

why is the name `loop` treated differently in PostgreSQL

answered Sep 16, 2014 at 21:50

1 vote

Postgresql query plan differs with limit value making the query slower for lower limits

answered Aug 8, 2014 at 1:06

1 vote

How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?

answered Oct 14, 2012 at 0:53

Stack Exchange Network

14 Answers

Aggressive Autovacuum on PostgreSQL

PostgreSQL data type text vs varchar without length

How do you figure out what planner cost constants to use in Postgres?

How to drop inheritance?

Why do psql queries take longer when inserting many rows. Why is it non linear

SQL Database vs Multiple Microsoft Access Databases

Postgresql: Two concurrent COPY FROM

How to configure postgresql to use multiple cores?

Why does PostgreSQL aggregate result in the Index or Seq scan outputting all columns of the table?

PostgreSQL hot standby promotion, multiple hot standbys

Which performance can I expect?

why is the name `loop` treated differently in PostgreSQL

Postgresql query plan differs with limit value making the query slower for lower limits

How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?