Reputation
25,219
Next tag badge:
97/100 score
29/20 answers
Badges
1 26 63
Newest
 Nice Answer
Impact
~734k people reached

Feb
5
awarded  Nice Answer
Jan
26
awarded  Enlightened
Jan
26
awarded  Nice Answer
Jan
24
awarded  Nice Answer
Jan
23
comment Is there some kind of table-level replication in PostgreSQL?
Table-level replication isn't built-in though pglogical aims to change that. Londiste, Slony-I and Bucardo offer trigger-based replication at a table level.
Jan
21
answered Postgres tablespace size is bigger than database size
Jan
21
revised Postgres tablespace size is bigger than database size
added 20 characters in body; edited tags
Jan
19
comment Postgresql Encryption by middleware
You'd have to write a proxy. Your best bet would be to modify PgBouncer or PgPool-II. Doing this will be extremely difficult since you'll probably have to change the data types on the fly (to/from bytea) among other challenges. You are likely to have more success modifying the client driver like PgJDBC, psqlODBC, etc. This will still be very hard, but more practical. Expect this to be a many-months project.
Dec
24
comment Export Postgres table on remote server to CSV file on local machine?
Um, sure it does. Use a here-document to feed psql a script, starting with BEGIN, then doing your \copy commands, then a COMMIT. Or use psql -f to run a script rather than using a here-document.
Dec
23
revised If else with 5 possible cases PostgreSQL
added 24 characters in body; edited tags
Dec
23
comment If else with 5 possible cases PostgreSQL
Cross-posted to stackoverflow.com/q/34430421/398670
Dec
22
comment Database encryption and key management with pg_crypto
@TheInternet You'd have to re-encrypt the private key to their new password as part of the password change operation, i.e decrypt with the old password and encrypt with the new. You would probably not want to try to use the same password as the PostgreSQL user/role in pg_authid because you can't hook into password change operations there.
Dec
21
answered Check lock count for PostgreSQL
Dec
18
comment autovacuum launcher process, but no autovacuum workers
Turn log_autovacuum on. I'd say it's just running fast enough that you don't notice the workers during their lifetime.
Dec
18
comment I'm sure there's a better way than this INSERT
Sounds like a freeform schema, so the usual answers would seem to apply. EAV, jsonb, etc.
Dec
17
awarded  Enlightened
Dec
17
awarded  Nice Answer
Dec
17
comment Postgresql join removal
It's generally called join removal in PostgreSQL. Unsure what the exact rules are; varies somewhat with version as it's been enhanced over time.
Dec
17
comment PostgreSQL on Cluster
Magic? There's nowhere near enough info here. Does the data naturally shard/partition, such that there are few or no inter-dependencies when sharded on a particular key, and you can do your computation without referring to other shards much or at all? i.e. is this data set, for this computation, embarrassingly parallel or close? Unless it is, do not assume sharding/horizontal scaling is best, crosstalk between nodes and node management quickly eats up the benefits, plus the complexity is huge and current tooling sucks. Look into postgres-XL and CitusDB if you must do this.
Dec
17
revised Postgres database encoding problem
added 665 characters in body