Hot answers tagged

3

The extract from pgadmin.log shows that for each output column of the result, pgadmin executes two queries against the catalog, one to obtain the formatted name of the type from its oid, another to obtain a potential base type. In your extract, if I'm counting right, the total number of such queries appears to be 106. From the ping time of 148 ms, let's ...


3

A collation is an SQL schema object that maps an SQL name to operating system locales. Whatever you shall setup as a default collation settings for the database. By default implicitly that collation will choose your database. In PostgreSQL nevertheless, the initial set of collation names is platform-dependent. There are no case insensitive ...


1

All these questions are basically answered in the documentation. To be specific: A role is an entity that can own database objects and have database privileges; a role can be considered a "user", a "group", or both depending on how it is used. That implies that internally there is no difference between these, except the LOGIN option. If you specify ...



Only top voted, non community-wiki answers of a minimum length are eligible