Re: Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume

Hello, Increase of access cost is logarithmic when we access by index, so partition often isn't a solution to improve performance, but a solution to solve human difficulties to manage huge amounts of data, to develop expensive parallel jobs and, in some cases, to improve performance for sequential

Re: Strategy for migrating from Oracle to PG

As far as I know, you don't need to create the users, if you create the user anyway before migration then ora2pg will skip the create statement, but objects under the user/schema will be created On Tue, Sep 5, 2023 at 10:24 AM Johnson, Bruce E - (bjohnson) < john...@pharmacy.arizona.edu> wrote: >

Re: ./configure doesn't make effect?

On 9/5/23 06:07, jacktby jacktby wrote: Sorry, I make a mistake, I should make install. That’s my fault FYI, that will not create the data/ directory by itself. You will need to do that yourself. See the steps here: https://www.postgresql.org/docs/current/install-short.html The above assum

Re: rollback to savepoint issue

Alvaro Herrera writes: > But it gets worse. If you create a procedure (no longer a function) > with a SAVEPOINT and ROLLBACK TO SAVEPOINT, it'll complain about the > ROLLBACK TO command, but not about SAVEPOINT; and if you remove that, > then it'll fail at runtime saying that SAVEPOINT is unsuppo

Re: ./configure doesn't make effect?

Sorry, I make a mistake, I should make install. That’s my fault > 2023年9月5日 20:08，Jeremy Garniaux 写道： > > Hi, > > The command you described: > > Le 05/09/2023 à 13:41, jacktby jacktby a écrit : >> rm -rf /data > has for effect to remove the /data directory and all its content. See: > https:/

Re: ./configure doesn't make effect?

On Tuesday, September 5, 2023, jacktby jacktby wrote: > I use “rm -rf /data”, the ‘/data’ is the prefix when I execute ./configure > command firstly, but after I ‘rm’ it, and use the command again, I can’t > get the /data content. Why? > > You might want to show a terminal transcript, your descri

Re: ./configure doesn't make effect?

On 05/09/2023 13:41 CEST jacktby jacktby wrote: > I use “rm -rf /data”, the ‘/data’ is the prefix when I execute ./configure > command firstly, but after I ‘rm’ it, and use the command again, I can’t get > the /data content. Why? ./configure only configures make. You need to run make install

Re: rollback to savepoint issue

On 2023-Sep-04, Erik Wienhold wrote: > On 04/09/2023 16:56 CEST David G. Johnston wrote: > > > On Monday, September 4, 2023, Erik Wienhold wrote: > > > > > On 04/09/2023 11:51 CEST Lorusso Domenico wrote: > > > > > > > The original code in embedded in a function, but the problem is the > > >

./configure doesn't make effect?

I use “rm -rf /data”, the ‘/data’ is the prefix when I execute ./configure command firstly, but after I ‘rm’ it, and use the command again, I can’t get the /data content. Why?

Re: Will PostgreSQL 16 supports native transparent data encryption ?

message from Stephen Frost mailto:sfr...@snowman.net> > > > Greetings, > > > * Ron (ronljohnso...@gmail.com ) wrote: > > On 8/21/23 18:49, Bruce Momjian wrote: > > > On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote: > > > > It is mentioned here > >

Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume

Hi Team, I'm working with a PostgreSQL table containing terabytes of data, and it grows by millions of rows weekly. Each row is identified by a [KSUID][1], and my primary read patterns are: 1. Retrieve a row by its KSUID. 2. List rows by `user_id` in descending order, pagination acceptable. Curr

Re: pg_dump/pg_restore and the magic of the search_path

Hi, thanks for your answer ! Sorry for being late... I'm sure :-) But I made more research and find the problem : the function I use... I'm using the gen_random_uuid() function wich is included into postgresql core since v13 and was originally into the pgcrypto extension. So when you don't prefi

Strategy for migrating from Oracle to PG

I have an oracle database with a bunch of schemas that are the data sources for bunch of web applications; what used to be called an ‘intranet’. I’ve installed pg2sql, and it’s working, and what I want to do is pretty much copy what I existing now as closely as possible. I've done ora2pg —proje