Questions tagged [postgresql]

72

votes

8

answers

PostgreSQL JSONB vs normalized tables for multi-tenant event metadata

asked 2026-05-03T11:45:00Z

34

votes

5

answers

Kubernetes pod stuck in CrashLoopBackOff after scaling beyond 20 replicas

kubernetes scaling oomkilled connection-pooling postgresql

asked 2026-03-20T07:55:00Z

55

votes

7

answers

PostgreSQL query planner choosing sequential scan despite btree index on large table

postgresql query-optimization indexing query-planner

asked 2026-01-09T08:15:00Z

12

votes

3

answers

Danger in killing autovacuum: VACUUM queries (to prevent wraparound)

database postgresql autovacuum

asked 2013-08-04T23:55:17.063

10

votes

2

answers

postgresql pgBench tool running user defined SQL script

sql postgresql multithreading benchmarking

asked 2013-08-01T14:38:23.617

121

votes

2

answers

How to Disconnect from a database and go back to the default database in PostgreSQL?

postgresql postgresql-9.1 postgresql-9.2

asked 2013-07-31T06:40:56.383

108

votes

8

answers

PostgreSQL server won't stop

postgresql macos terminal

asked 2013-07-29T17:15:48.303

59

votes

7

answers

Where is psql client history kept? (~/.psql_history non-existent!)

postgresql psql

asked 2013-07-29T13:06:20.860

8

votes

2

answers

Execute a String Sql in PostgreSQL

postgresql

asked 2013-07-25T10:36:42.800

8

votes

2

answers

How to speed up min/max aggregates in Postgres without an index that is unnecessary otherwise

sql performance postgresql

asked 2013-07-24T17:41:34.343

16

votes

3

answers

Cannot connect to PostgreSQL Remotely on Amazon EC2 instance using PgAdmin

postgresql amazon-ec2 pgadmin

asked 2013-07-21T08:10:02.543

10

votes

3

answers

how to extract specific word from string in Postgres

sql postgresql

asked 2013-07-15T11:00:09.593

255

votes

8

answers

Group query results by month and year in postgresql

sql postgresql datetime

asked 2013-07-05T15:18:24.213

70

votes

4

answers

Join postgres table on two columns?

postgresql

asked 2013-07-04T09:26:41.703

11

votes

2

answers

Returning result from SELECT with node-postgres

node.js postgresql rest

asked 2013-07-03T06:52:25.150

10

votes

5

answers

Store string with special characters like quotes or backslash in postgresql table

sql postgresql

asked 2013-07-03T06:46:51.247

10

votes

2

answers

Postgresql 9.2 installation on Ubuntu 12.04

postgresql ubuntu ubuntu-12.04 postgresql-9.2

asked 2013-07-01T07:47:12.307

122

votes

7

answers

Get DB owner's name in PostgreSql

postgresql

asked 2013-06-18T09:27:09.690

27

votes

1

answers

Pass array literal to PostgreSQL function

php sql arrays postgresql parameter-passing

asked 2013-06-16T23:48:10.497

16

votes

1

answers

Why does Play action fail with "no suitable driver found" with Slick and PostgreSQL?

postgresql scala playframework slick

asked 2013-06-11T22:02:56.147

120

votes

10

answers

Createuser: could not connect to database postgres: FATAL: role "tom" does not exist

database postgresql

asked 2013-06-06T22:05:44.603

9

votes

2

answers

PostgreSQL - INNER JOIN two tables with a LIMIT

sql postgresql

asked 2013-06-03T08:41:57.597

8

votes

2

answers

Slow OR statement in postgresql

sql postgresql

asked 2013-05-29T13:42:29.443

103

votes

6

answers

PG::Error: ERROR: new encoding (UTF8) is incompatible

ruby-on-rails ruby postgresql

asked 2013-05-24T14:06:17.257

10

votes

3

answers

postgres. plpgsql stack depth limit exceeded

postgresql plpgsql

asked 2013-05-22T16:15:49.043

25

votes

5

answers

Postgres COPY FROM csv file- No such file or directory

postgresql import psql csv

asked 2013-05-17T21:36:42.473

31

votes

3

answers

How to install Postgres extensions at database creation?

ruby-on-rails postgresql

asked 2013-05-17T14:13:15.883

9

votes

2

answers

Amazon Redshift how to copy from s3 and set a job_id

postgresql amazon-web-services amazon-redshift

asked 2013-05-13T14:59:03.020

20

votes

2

answers

How to limit the maximum display length of a column in PostgreSQL

sql postgresql

asked 2013-05-09T14:40:36.050

83

votes

23

answers

Psycopg2 image not found

python macos postgresql psycopg2

asked 2013-05-06T22:00:27.373

29

votes

4

answers

How to syntax check PostgreSQL config files?

postgresql syntax configuration-files

asked 2013-05-02T08:15:42.807

13

votes

3

answers

date_sub ok with mysql, ko with postgresql

sql postgresql

asked 2013-05-01T14:16:09.323

11

votes

1

answers

How to migrate database from Postgres to MySQL?

mysql postgresql migration

asked 2013-04-24T10:36:13.270

12

votes

5

answers

How to insert binary data into a PostgreSQL BYTEA column using the C++ libpqxx API?

c++ postgresql libpqxx

asked 2013-04-16T22:06:40.597

32

votes

4

answers

postgres 'psql' command is not recognized in windows environment

ruby-on-rails database postgresql

asked 2013-04-08T01:13:59.207

30

votes

8

answers

Call getNextException to see the cause : How to make Hibernate / JPA show the DB server message for an exception

java hibernate postgresql jpa jdbc

asked 2013-04-06T07:44:13.273

9

votes

1

answers

How to bulk insert only new rows in PostreSQL

sql postgresql insert duplicates bulk

asked 2013-04-05T12:56:55.110

8

votes

1

answers

Hebrew dictionary for PostgreSQL on Heroku?

postgresql heroku hebrew

asked 2013-04-04T07:26:54.487

9

votes

1

answers

Updating database rows without locking the table in PostgreSQL 9.2

postgresql sql-update database-cursor

asked 2013-04-02T17:45:54.630

34

votes

1

answers

When does "select for update" lock and unlock?

database postgresql locking

asked 2013-04-01T01:53:45.457

75

votes

5

answers

How to compute the sum of multiple columns in PostgreSQL

postgresql

asked 2013-03-30T14:22:23.300

69

votes

3

answers

Dropping column in Postgres on a large dataset

postgresql database-design ddl database-performance postgresql-9.2

asked 2013-03-29T08:44:38.027

67

votes

5

answers

PostgreSQL query to count/group by day and display days with no data

sql postgresql join group-by

asked 2013-03-28T20:04:09.843

572

votes

6

answers

How to list the tables of schemas in PostgreSQL?

postgresql command psql postgresql-9.1 dbtable

asked 2013-03-26T17:56:59.277

42

votes

5

answers

Deleting using LEFT JOIN

sql postgresql join left-join

asked 2013-03-20T11:14:24.800

44

votes

1

answers

Postgresql - detect changes and call webservice

postgresql

asked 2013-03-19T16:36:09.717

11

votes

1

answers

How to reduce number of connections using SQLAlchemy + postgreSQL?

python postgresql heroku sqlalchemy flask

asked 2013-03-19T10:32:22.150

29

votes

6

answers

Alphanumeric case in-sensitive sorting in postgres

postgresql postgresql-9.1

asked 2013-03-15T08:13:20.207

11

votes

3

answers

Hibernate batch-delete vs single delete

java hibernate postgresql

asked 2013-03-14T00:43:20.677

40

votes

2

answers

Loop on tables with PL/pgSQL in Postgres 9.0+

postgresql variables loops plpgsql tablename

asked 2013-03-07T08:26:37.277

Questions tagged postgresql