Re: What to do with a PAAS-pg server

2024年10月31日(木) 0:32 alexander al (leiden) : > > Hi, > > we have a supplier (via our client) who has an self build PAAS-version > of postgresql. Ok, you would say, that's fine. But, there is always an > but, we think the settings are not quite ok. We really want to know how > much memory etc there i

Re: What to do with a PAAS-pg server

On Wed, Oct 30, 2024 at 11:49:29AM -0400, Ron Johnson wrote: > Settings, like "SELECT * FROM pg_settings;" This query will show you the non-default settings: SELECT name, current_setting(name), source FROM pg_settings WHERE source NOT IN ('default', 'override'); -

Re: Plans for partitioning of inheriting tables

On 10/25/24 11:47, Thiemo Kellner wrote: Am 25.10.2024 um 17:57 schrieb Adrian Klaver: I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using

Re: COPY documentation with regard to references constraints

On Thu, Oct 31, 2024 at 1:04 PM Bruno Wolff III wrote: > I was unable to find any documentation clarifying if using COPY to load a > table with rows referencing others rows in the same table, whether I > had to worry about ordering of the input. > What I found (in 17) is that even if the reference

Re: Index Partition Size Double of its Table Partition?

On Oct 31, 2024, at 10:02 AM, Don Seiler wrote:On Wed, Oct 30, 2024 at 4:59 PM David Mullineux wrote:Are you able to cluster the table ? The idea is that rows ordered in the same way  as the index might reduce it's size ? I'm not sure on this. There are other indexes on these t

Re: Index Partition Size Double of its Table Partition?

On Wed, Oct 30, 2024 at 4:59 PM David Mullineux wrote: > Are you able to cluster the table ? The idea is that rows ordered in the > same way as the index might reduce it's size ? > I'm not sure on this. There are other indexes on these table partitions as well. Another bit of useful info that I

Re: COPY documentation with regard to references constraints

On Thu, 2024-10-31 at 06:38 -0500, Bruno Wolff III wrote: > I was unable to find any documentation clarifying if using COPY to load a > table with rows referencing others rows in the same table, whether I > had to worry about ordering of the input. I cannot find it in the documentation either, b

Re: COPY documentation with regard to references constraints

On Thu, Oct 31, 2024 at 13:15:34 +0100, Dominique Devienne wrote: AFAIK, DEFERRABLE is for temporary violations crossing statement boundaries, to postpone the enforcement of FKs at COMMIT time of the transaction. While a single COPY is just one statement, so whether a temporary violation for

COPY documentation with regard to references constraints

I was unable to find any documentation clarifying if using COPY to load a table with rows referencing others rows in the same table, whether I had to worry about ordering of the input. What I found (in 17) is that even if the references constraint wasn't set as deferrable, I could have rows for

RE: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

Thank you very much for your response. After changing the "password_encryption" option to "md5" in the postgresql.conf file, the server can now successfully connect to the database. Thanks again for your help. -Original Message- From: Adrian Klaver Sent: Wednesday, October 30, 2024 12:0