I need a person that is an expert with PostGres to help up troubleshoot an issue and it help us with performance tuning of the database. Our current system we need assistance on is:
CentOS Linux release 7.2.1511 (Core)
psql (PostgreSQL) 9.4.9
The issue we are experiencing is:
When trying to create a Foreign key Constraint from a newly created table (FOO) to a certain existing table (BAR) the process goes into waiting. We are able to successfully create foreign keys to any other table except this one, For example table FOO with a Foreign key to BUU works successfully. When trying to reindex BAR the process goes into waiting. I believe the table BAR is corrupt, although I can successfully select from the table.
Hi,
I could help you.
We manage big Postgres db (500 tables and 3000+ functions), and worked on conversions from SQL Server and Oracle to Postegres sql.
Please send me the db backup with all the instructions.
I will have a look and let you know.
Ciao
Armando
"Hello, I'm David"
I can provide you perfect work as you looking for .
we can discuss more in chat .
I will be waiting for your response .
Thank you
I have very great experience about your project , if you want discuss more please send me a text