PostGres Expert Needed -2

Please read this post in its entirety before bidding..

1.) DO NOT RESPOND if you are NOT an expert with PostgreSQL

2.) DO NOT RESPOND If your profile does not have anything about architecting or supporting a PostgreSQL Database

3.) I will not be able to send you anything from the database, everything will be done via screen sharing. It will be a collaborative session with my engineers. If this is not acceptable DO NOT RESPOND

I need a person that is an expert with PostgreSQL to help us troubleshoot an issue with a database upgrade and to help us with performance tuning of the database and server. 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.

Skills: Database Administration, Hadoop, Linux, MySQL, PostgreSQL

See more: sharepoint server installation expert needed, clickbank expert needed, net graphics expert needed, postgresql commercial support, pgx services, postgresql consul, postgresql support, 2ndquadrant, j2me expert needed, php web scraping expert needed, zen cart expert needed, mod rewrite expert needed, linux expert needed, digg expert needed, volusion expert needed, photoshop expert needed san jose, web security expert needed, joomla expert needed, php expert needed

About the Employer:
( 1 review ) Chicago, United States

Project ID: #16014686

4 freelancers are bidding on average $22/hour for this job


We are an exceptionally competent team with an average experience of 10+ years in various fields of Information Technology. We have rich experience working with PostgreSql. We have worked with clients across industrie More

$28 USD / hour
(9 Reviews)

Hi! I've seen your problem on freelancer before. In order to help you (without any reason) i'd tell that $5/hr and expert (as you write) are incompatible things. Could you please show you query execution plan an pgsql More

$38 USD / hour
(6 Reviews)

Database Administrator, 8 years experience, infrastructure dba, for SQL Server, PostgreSQL. Recently focused with AWS and virtualization, my last good experience with PostgreSQL 9.2 and 9.3 include configuring HA envi More

$5 USD / hour
(2 Reviews)
$16 USD / hour
(0 Reviews)