[BUGS] BUG #8000: ExclusiveLock on a simple SELECT ?
The following bug has been logged on the website: Bug reference: 8000 Logged by: Roberto Email address: roberto.menon...@netspa.it PostgreSQL version: 9.2.3 Operating system: CentOS 5.6 (Final) Description: Hy, after upgrading to version 9.2.3 we having a performance degradation. We are investigating the matter on several fronts. We've seen that Postgres (9.2.3) creates ExclusiveLock even with simple SELECT * From myschema.mytable. Is it normal ? Thank you -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8107: How to downgrade database from 9.2.3 to 8.4 ?
The following bug has been logged on the website: Bug reference: 8107 Logged by: Roberto Email address: roberto.menon...@netspa.it PostgreSQL version: 9.2.3 Operating system: CentOS 5.6 (Final) Description: Hy. This is not a bug but a simple request ! Is there a way to downgrade a database from version 9.2.3 to 8.4.x ? I tried a pg_dump from 9.2.3 and a pg_restore from 9.2.3 TO a 8.4.7 server. but I receive several errors. Does it exist another way ? Thank you. Roby -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
