On Fri, Jul 7, 2017 at 10:12 AM, Shaun Thomas
wrote:
>> I don't think the downstream dependencies will let that work without
>> rebuilding them as well. The drop fails (without a cascade), and the other
>> views and matviews that are built off of this all simply point to x_old.
>
> Wow, ouch. Ye
On 2017-07-19 14:23, Dinesh Chandra 12108 wrote:
Dear expert,
I have to create a user which have permission to CREATE SCHEMAS AND
CREATE DATABASE OBJECTS in database.
I am using postgres 9.1.
Could you please assist me?
Access control is managed using the GRANT command:
https://www.postgres
Dear expert,
I have to create a user which have permission to create schemas and create
database objects in database.
I am using postgres 9.1.
Could you please assist me?
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
Justin,
Thanks for the extensive reading list, very educative.
After reading
https://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architecture/
I was thinking that it could be a NUMA/THP-related problem.
Turning off THP solved the "swap storm" problem. Some queries are even 40%
faste
