Reputation
8,179
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~377k people reached

5h
comment pg_restore fails with materialized view
And the fdw and related stuff doesn't throw an error, too?
11h
reviewed Close How to emulate transactions if you don't have access to them?
14h
reviewed Close Compatibility Level
14h
reviewed Close Requirements for Setting up mysql cluster
14h
comment Requirements for Setting up mysql cluster
I would not exactly call something with 2 GB RAM a DB server these days... Give them at least that much RAM that fits the whole DB easily (as it is not very big).
14h
reviewed Close MariaDB Galera Cluster Deployment
14h
comment Postgres Partition Table Trigger inserting duplicate records
This might help you (I don't really like the approach, but still): technology-ebay.de/the-teams/mobile-de/blog/…
17h
comment Postgres 9.4, replication slots, doesn't work failover master
Great! What I was not sure about was if the replication slot itself is replicated - apparently, you have to create it after failover.
17h
comment Postgres 9.4, replication slots, doesn't work failover master
@user2627744 Do any errors pop up in the logs?
20h
comment doing a insert while selecting an specific user
No, possibly not. You have a user table around, right? It's completely missing from your question how you migrate the data there. It should, at least in the beginning, act as a map between the old and the new ID, so that you can find all related rows in other tables both via the old and the new ID.
1d
answered Postgres 9.4, replication slots, doesn't work failover master
1d
comment Is there a parser for Postgres' auto_explain to make it easier to read and understand?
This does not really help figuring out what the actual log line tries to tell - it is really very convoluted. Sometimes it contains several EXPLAIN ANALYZE outputs mixed with other information.
1d
comment doing a insert while selecting an specific user
Why don't you simply add an old_id and/or an old_user_id columns to the new table?
1d
comment Postgres Partition Table Trigger inserting duplicate records
@kirti I mean when you change the trigger to BEFORE?
1d
comment Postgres Partition Table Trigger inserting duplicate records
Could you tell if PostgreSQL itself complains when inserting a row?
1d
comment Postgres Partition Table Trigger inserting duplicate records
@Andomar triggers are not necessarily evil, one of the established use cases in PostgreSQL is exactly partitioning.
1d
comment SELECT DISTINCT on multiple columns
Why are you doing this array and cursor magic? @ypercube's solution does the work and it's very easy to wrap into a SQL language function.
1d
reviewed Edit InnoDB Index Doesn't Fit in Memory
1d
revised InnoDB Index Doesn't Fit in Memory
Moved additional info posted as answer into question.
1d
reviewed Reviewed change the name of the database according the changes in while loop