Re: Question on full vacuum clearing waste space

On Sat, Jun 6, 2020 at 11:24 PM Wenjun Che wrote: > Hi > > I am testing full vacuum with pg 10.10 on AWS RDS. I noticed for some > tables, the number of waste bytes stays at a few MB after I run full > vacuum. I double-checked that there are no long running transactions, no > orphaned prepared

Question on full vacuum clearing waste space

Hi I am testing full vacuum with pg 10.10 on AWS RDS. I noticed for some tables, the number of waste bytes stays at a few MB after I run full vacuum. I double-checked that there are no long running transactions, no orphaned prepared transactions and no abandoned replication slots. Here is outpu

Re: When to use PARTITION BY HASH?

On 6/5/20 8:51 AM, Jeff Janes wrote: On Fri, Jun 5, 2020 at 6:12 AM Oleksandr Shulgin mailto:oleksandr.shul...@zalando.de>> wrote: [snip] For a bulk load you'd likely want to go with an empty partition w/o indexes and build them later, after loading the tuples. That only works if the

Re: Should I enforce ssl/local socket use?

Michel Pelletier writes: > Hello, > > I'm the author of the pgsodium cryptography library. I have a question > about a best practice I'm thinking of enforcing. Several functions in > pgsodium generate secrets, I want to check the Proc info to enforce that > those functions can only be called

Re: Index no longer being used, destroying and recreating it restores use.

I'll attempt this next week. On Fri, Jun 5, 2020, 21:11 Michael Lewis wrote: > Those row estimates are pretty far off. > > Standard indexes and partial indexes don't get custom statistics created > on them, but functional indexes do. I wonder if a small function > needs_backup( shouldbebackedup,

Re: Should I enforce ssl/local socket use?

On Sat, Jun 6, 2020 at 1:52 PM Tom Lane wrote: > Michel Pelletier writes: > > I'm the author of the pgsodium cryptography library. I have a question > > > Any thoughts? Is this an insufferably rude attitude? > > I would say yes. > I'd say that settles it then, thank you! -Michel

Re: Should I enforce ssl/local socket use?

Michel Pelletier writes: > I'm the author of the pgsodium cryptography library. I have a question > about a best practice I'm thinking of enforcing. Several functions in > pgsodium generate secrets, I want to check the Proc info to enforce that > those functions can only be called using a local

Should I enforce ssl/local socket use?

Hello, I'm the author of the pgsodium cryptography library. I have a question about a best practice I'm thinking of enforcing. Several functions in pgsodium generate secrets, I want to check the Proc info to enforce that those functions can only be called using a local domain socket or an ssl co

Re: Multitenent architecture

Hi guys - apologies for jumping into the middle of this, but it touches on precisely one of the topics I'll have to deal with soon. We're standing up a pharmacovigilance / drug safety platform managing ICSRs (HL7 "individual case safety reports" that must be FDA/ICH compliant) and will be dealing w

Re: Multitenent architecture

On Sat, Jun 6, 2020 at 3:14 AM Vasu Madhineni wrote: > Hi Rob, > > Our environment is medical clinical data, so each clinic as a tenant. > Approximately 500+ tenants with 6TB data. > > Thank you in advance. > > There's a good article on the AWS blog on multi tenancy with postgres: https://aws.am

Re: When to use PARTITION BY HASH?

On Wed, Jun 3, 2020 at 4:55 AM Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > > Do you also assign the partitions to different tablespaces as you've > hinted below or do you see performance improvement from partitioning > alone? How does that work? Does it give better results than u

Re: Multitenent architecture

Hi Rob, Our environment is medical clinical data, so each clinic as a tenant. Approximately 500+ tenants with 6TB data. Thank you in advance. Regards, Vasu Madhineni On Fri, Jun 5, 2020 at 6:09 PM Rob Sargent wrote: > > > On Jun 5, 2020, at 2:54 AM, Vasu Madhineni wrote: > >  > If the data

Re: Potential optimisation for the creation of a partial index condition over a newly created nullable, non-default-valued column?

On Fri, 5 Jun 2020 at 20:15, David Rowley wrote: > While it could be technically possible to do something like check the > xmin of the pg_attribute record for all columns mentioned in the > index's predicate all are set to the current transaction ID and the > index predicate refutes an expression

Re: Postgres12 - Confusion with pg_restore

Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Friday, 5 June 2020 19:35, Tom Lane wrote: > Laura Smith n5d9xq3ti233xiyif...@protonmail.ch writes: > > > But doesn't the second half of my original post demonstrate that I tried > > that very thing ? I did try creating