7,044 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 2 years, 10 months
seen yesterday

Nov
11
comment Does PostgreSQL have a variable character storage layer that optimizes storage space by automatic dedupe?
You mean bytes?
Nov
11
revised Postgresql doesn't accept replication connection
added 82 characters in body
Nov
11
comment Does PostgreSQL have a variable character storage layer that optimizes storage space by automatic dedupe?
There is no mechanism that will do this for you behind the scenes. However, you can normalize these data into two separate tables (purchased_name and purchased_description, for example) and have a foreign key in the original table referencing these two.
Nov
10
comment Postgresql cluster over nfs
Yeah, exactly that's the idea behind replication - to have a replica.
Nov
10
revised PostgreSQL roles versus users, grant permissions
added 266 characters in body
Nov
10
comment Does Postgres shutdown gracefully when I restart my Mac?
From the PostgreSQL logs, you will see how it is being shut down. Otherwise yes, it should close PostgreSQL nicely.
Nov
10
revised PostgreSQL: Creation date of a table
added 6 characters in body
Nov
8
comment Are PostgreSQL dynamic arrays more wasteful than plain text?
I think the most important thing here is the last sentence.
Nov
8
comment Error: /var/lib/postgresql/9.3/main is not accessible or does not exist
And what was the weird error message? How did you take the dump? Is your installation in the directory in the title?
Nov
7
comment Are PostgreSQL dynamic arrays more wasteful than plain text?
Exactly what do you mean by dynamic arrays? How do they differ from the usual arrays?
Nov
7
revised why pg_restore ignores --create ? Error: failed: FATAL: database “new_db” does not exist
deleted 10 characters in body
Nov
7
comment PostgreSQL: Creation date of a table
unfortunately, it won't work on 'plain' PostgreSQL as this view is a greenplum addition.
Nov
7
revised PostgreSQL: Creation date of a table
formatting
Nov
7
reviewed No Action Needed Change Data Types large Live table
Nov
7
reviewed Close Time Series data for controllers connected to other devices
Nov
6
comment Best design to handle multiple query keys
So, could you please clarify why do you want only one table? That would possibly save us a lot of unnecessary discussion.
Nov
6
comment Best design to handle multiple query keys
@MinimeDJ your approach is simply not one for an RDBMS. That also means that you can do it, if you really want, but most probably you'll get an awful performance.
Nov
6
comment Assign to NEW by key in a Postgres trigger
I haven't thought about hstore, it's much simpler than my approach.
Nov
6
answered Assign to NEW by key in a Postgres trigger
Nov
6
comment Best design to handle multiple query keys
@MinimeDJ Yes, there is, it's called normalization ;)