Hello,
We were planing to upgrade from 9.0 to to 9.3. While
investigating on the performance side, we stumbled upon a link which
says there may be performance degradation on 9.3:
http://postgresql.1045698.n5.nabble.com/upgrade-from-9-2-x-to-9-3-causes-significant-performance-degrada
Hello,
We are planning to upgrade Postgres from 9.0 to 9.3. Was wondering
if there are any serious changes that I have to look out for
(syntax/datatypes changes) so that my code does not break.
Thanks in advance.
- Karthik
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
A full dump and restore would definitely help. I tend not to suggest
that often because I work with very large databases that are usually
extremely cumbersome to dump and restore.
But yeah, if you can get a successful pg_dump from your database, a
restore should obviously clean up all of you
Hi Shaun,
We reindexed all the primary and unique keys of all the tables, But we
did not reindex the tables. You think we should do that also ?
Yes, you need to reindex. Part of the problem with this kind of table
corruption, is that PostgreSQL has applied data and index page
modification
server up. We are trying to play the
difference in data by checking the log files(statement logs). You think
there is any other easy alternatives ?
Thanks in advance,
- Karthik
On Thursday 26 June 2014 01:09 AM, Shaun Thomas wrote:
On 06/25/2014 06:29 AM, Karthik Iyer wrote:
[2] We also have a
tries.
2. there are duplicate values for primary keys
Postgres version that we use:
9.0.13
Postgres conf : http://pastebin.com/raw.php?i=B0diaitG
Any help here is appreciated.
Thanks in advance.
- Karthik Iyer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
