Question : I have a PostgreSQL database on an Amazon RDS instance. I want to have a local dump of […]
Tag: postgresql-9.3
PostgreSQL performance worse when adding CPUs
Question : I ran into a strange behaviour when benchmarking PostgreSQL. The setup is like this: Virtual box VM, with […]
Postgres 8.3 faster than 9.3?
Question : Our software product currently ships on Windows 7 with Postgres 8.3 as its database. On a busy site, […]
What causes large INSERT to slow down and disk usage to explode?
Question : I have a table of about 3.1 million rows with the following definition and indexes: CREATE TABLE digiroad_liikenne_elementti […]
What is the better way to handle a different types of measurement in grocery store items database
Question : While designing a DB for grocery shop, I came across a requirement of “same product available in different […]
Setting password for 9.3 PostgreSQL server [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Specifying a username while running initdb causes error in log on start of PostgreSQL process
Question : I have been forced to use a different default username for PostgreSQL. Before you ask: no, this is […]
PostgreSQL determine column type when data_type is set to ARRAY
Question : I came across an oddity where PostgreSQL sets the data_type to ARRAY in the information_schema.columns table. I did […]
Slow query when adding additional where clause
Question : Here’s my setup (Postgres 9.3) Posts project_id Messages post_id kind updated_at I’m trying to get the most recently […]
Why postgres is using an odd index with no relation to the query
Question : (Debian 7, Postgres 9.3, dedicated machine with huge cache) I have one big table called process_data (14gb) and […]