Re: efficiency random values / sequential ID values in indexes

Thanks On Mon, Apr 15, 2024 at 6:19 PM Ron Johnson wrote: > On Mon, Apr 15, 2024 at 6:05 AM Sanjay Minni > wrote: > >> Hi >> >> Is there any appreciable difference in using random values or sequential >> values in indexes >> >> in a multi tenanted

efficiency random values / sequential ID values in indexes

Hi Is there any appreciable difference in using random values or sequential values in indexes in a multi tenanted application there is a choice that the single field ID's value is totally random / UUID or the numbers are created with a prefix of the tenant. Since all access will be within a

Re: Multiple connections over VPN password fail error

HOD host all all scram-sha-256 (or "md5" - second user is only able to connect if this is "trust" regards Sanjay On Fri, Feb 9, 2024 at 2:44 PM Sanjay Minni wrote: > so why do I get a password error when i try to connect 2 users over V

Re: Multiple connections over VPN password fail error

THOD host all all scram-sha-256 and whats the best option keeping security in mind regards Sanjay On Fri, Feb 9, 2024 at 1:26 PM Daniel Gustafsson wrote: > > On 9 Feb 2024, at 08:41, Sanjay Minni wrote: > > > while trying to make multiple connects

Multiple connections over VPN password fail error

USER ADDRESS METHOD host all all trust `<=(from the earlier scram-sha-256) is this the way and is this correct from a security point of view ? regards Sanjay Minni

Re: timestamp default current_timestamp not working

Its an insert and my insert SQL contains the column timestamp and value nil. Will it work if the SQL contains timestamp through value is nil On Tue, 14 Dec, 2021, 9:20 pm Adrian Klaver, wrote: > On 12/14/21 07:36, Sanjay Minni wrote: > > Hi > > > > I am not getting the ti

timestamp default current_timestamp not working

ties->columns by entering CURRENT_TIMESTAMP in the default column) why is the timestamp value not being automatically inserted by the system with warm regards Sanjay Minni

any default columns for tracking / auditing purpose

In Postgres 12 and up, are there any default columns available which could be useful for tracking / auditing purposes ? e.g. - real user who entered / updated the data - timestamp when data was updated / entered where can i get a list of such default columns (if any) - which could be accessed

Re: historical log of data records

it by keeping a parallel set of tables and copying the row being replaced into the parallel table set, or, keeping all record versions in a single table only and a flag to indicate the final / current version) I am looking is there are better ways to do it with warm regards Sanjay Minni +91-9900

Re: historical log of data records

Are you referring to Table Partitioning ? https://www.postgresql.org/docs/14/ddl-partitioning.html with warm regards Sanjay Minni +91-9900-902902 http://planage.com https://www.linkedin.com/in/sanjayminni/ On Tue, 16 Nov 2021 at 14:50, Laurenz Albe wrote: > On Tue, 2021-11-16 at 13:56 +0

reading this group other than thru mails

Is there any way to read this group other than thru mails or search old mails other than thru the interface at https://www.postgresql.org/list/pgsql-general. I dont seem to find these very friendly. Sanjay Minni +91-9900-902902

historical log of data records

control. Each has its pros and cons. In Postgres would i have to follow the same methods or are there any features / packages available ? regards Sanjay Minni

Approach to creating users in Database

benefit in (B) above - i.e. recreating each user in the postgres database So what am i missing. A change in approach later can mean a huge rework later with warm regards Sanjay Minni +91-9900-902902 http://planage.com https://www.linkedin.com/in/sanjayminni/