Re: Date created for tables

2019-12-24 Thread Ron
On 12/24/19 8:58 PM, Rob Sargent wrote: On Dec 24, 2019, at 11:48 AM, Ron wrote:  On 12/24/19 1:14 PM, Rob Sargent wrote: If there's not enough time and motivation for the developers to implement CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in the first place.

Re: Date created for tables

2019-12-24 Thread Rob Sargent
> On Dec 24, 2019, at 11:48 AM, Ron wrote: > >  On 12/24/19 1:14 PM, Rob Sargent wrote: >> >>> If there's not enough time and motivation for the developers to implement >>> CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in >>> the first place. We're adults; we unde

Re: Date created for tables

2019-12-24 Thread Ron
On 12/24/19 1:14 PM, Rob Sargent wrote: If there's not enough time and motivation for the developers to implement CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in the first place. We're adults; we understand that OSS projects have limited resources, and won't go off

Re: Date created for tables

2019-12-24 Thread Rob Sargent
> If there's not enough time and motivation for the developers to implement > CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in > the first place. We're adults; we understand that OSS projects have limited > resources, and won't go off and pout in the corner. > > Bu

Re: Date created for tables

2019-12-24 Thread Ron
On 12/24/19 12:14 PM, Adrian Klaver wrote: On 12/24/19 8:44 AM, Ron wrote: On 12/24/19 10:39 AM, Adrian Klaver wrote: On 12/23/19 6:14 PM, Ron wrote: On 12/23/19 7:01 PM, Bruce Momjian wrote: Is this something that has been considered for implementation? I wrote a blog about this: https:/

Re: Date created for tables

2019-12-24 Thread Adrian Klaver
On 12/24/19 8:44 AM, Ron wrote: On 12/24/19 10:39 AM, Adrian Klaver wrote: On 12/23/19 6:14 PM, Ron wrote: On 12/23/19 7:01 PM, Bruce Momjian wrote: Is this something that has been considered for implementation? I wrote a blog about this: https://momjian.us/main/blogs/pgblog/2017.html#Nove

Re: Date created for tables

2019-12-24 Thread Ron
On 12/24/19 10:39 AM, Adrian Klaver wrote: On 12/23/19 6:14 PM, Ron wrote: On 12/23/19 7:01 PM, Bruce Momjian wrote: On Thu, Dec  5, 2019 at 05:10:20PM +, Chloe Dives wrote: Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there a

Re: Postgres cursor taking 2 hrs to update the table

2019-12-24 Thread Adrian Klaver
On 12/24/19 2:32 AM, M Tarkeshwar Rao wrote: Hi, I have the 10 application processes(each process having 12 threads and each of have updating 8 million rows in the shared memory) which are reading the data from single postgres database. We are using database cursors in C++ to fetch the data a

Re: Date created for tables

2019-12-24 Thread Adrian Klaver
On 12/23/19 6:14 PM, Ron wrote: On 12/23/19 7:01 PM, Bruce Momjian wrote: On Thu, Dec 5, 2019 at 05:10:20PM +, Chloe Dives wrote: Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there are a few things that I still miss. One of th

Re: Date created for tables

2019-12-24 Thread Fabrízio de Royes Mello
Em seg., 23 de dez. de 2019 às 23:14, Ron escreveu: > > You all are grossly over-complicating this. > Maybe we are really very conservative, but everyone needs to understand that every single piece of code added to core is our responsibility to maintain and make sure don't break the whole thing.

Re: logical replication protocol

2019-12-24 Thread Scott Ribe
> On Dec 24, 2019, at 6:12 AM, Tatsuo Ishii wrote: > > The logical replication protocol builds on the primitives of the > physical streaming replication protocol as stated in the document. The > explanation of 'k' and 'w' messages can be found in the "Streaming > Replication Protocol" section. T

Re: logical replication protocol

2019-12-24 Thread Tatsuo Ishii
> I haven't been able to find documentation on the actual messages used in the > logical replication protocol ('k' & 'w', lower case). I've figured things out > mostly by reading pg_recvlogical.c, but "Read The Fine Source" doesn't seem > in line with the way PG usually does it ;-) > > Did I mi

logical replication protocol

2019-12-24 Thread Scott Ribe
I haven't been able to find documentation on the actual messages used in the logical replication protocol ('k' & 'w', lower case). I've figured things out mostly by reading pg_recvlogical.c, but "Read The Fine Source" doesn't seem in line with the way PG usually does it ;-) Did I miss a doc som

Postgres cursor taking 2 hrs to update the table

2019-12-24 Thread M Tarkeshwar Rao
Hi, I have the 10 application processes(each process having 12 threads and each of have updating 8 million rows in the shared memory) which are reading the data from single postgres database. We are using database cursors in C++ to fetch the data and updating the shared memory. There is the tim

Re: Date created for tables

2019-12-24 Thread Thomas Kellerer
Ron schrieb am 24.12.2019 um 03:14: Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there are a few things that I still miss. One of those is being able to see the created and last modified dates for database objects. Is this something