Re: Bulk Inserts

On 8/9/19 3:06 PM, Souvik Bhattacherjee wrote: Hi, I'm trying to measure the performance of the following: Multiple txns inserting tuples into a table concurrently vs single txn doing the whole insertion. *new table created as:* create table tab2 ( id serial, attr1 integer not null, attr2

Bulk Inserts

Hi, I'm trying to measure the performance of the following: Multiple txns inserting tuples into a table concurrently vs single txn doing the whole insertion. *new table created as:* create table tab2 ( id serial, attr1 integer not null, attr2 integer not null, primary key(id) ); *EXP 1: inserts

Re: How to check if a field exists in NEW in trigger

On 2019-08-07 15:54:33 -0700, Igal @ Lucee.org wrote: > There is no reason, however, for an email address to be not-lower-cased, so > while in some cases (no pun intended) it makes sense to keep the original > CaSe while performing a case insensitive comparison, when it comes to email > addresses

Re: PostgreSQL 8.4 Tablespace Inconsistency

On Fri, Aug 9, 2019 at 7:15 AM Tom Lane wrote: > Harold Falkmeyer writes: > > As an example of the seeming inconsistency, pg_class indicated that > certain > > tables and indexes were on reltablespace 0, which, as we understood, > refers > > to pg_default, which, coincidentally is listed with

Re: Understanding PostgreSQL installer debug log

On 2019-08-09 16:55:13 +0530, Ramesh Maddi wrote: > performing post-bootstrap initialization ... Failed to initialize the database > cluster with initdb with the error "invalid byte sequence for encoding "UTF8" > > Script stderr: >  FATAL:  invalid byte sequence for encoding "UTF8": 0xeb 0x2f

Re: DRY up GUI wiki pages

On Fri, Jul 26, 2019 at 9:49 PM Alvaro Herrera wrote: > > On 2019-Jul-10, Steve Atkins wrote: > > > > On Jul 10, 2019, at 7:38 PM, Bruce Momjian wrote: > > > >> I'd like to DRY them up so there aren't two lists which confuses > > >> newcomers. Any objections? If not I'll probably make one of

Re: Updating 3-table dataset

Il 09/08/19 16:50, Luca Ferrari ha scritto: On Fri, Aug 9, 2019 at 2:29 PM Moreno Andreo wrote: Hi all, I don't know if that's the heat burning my brain but I can't find a solution to what seemed a simple operation to me. I have 3 tables create table t_all { id uuid, ref_id uuid (FK

Re: Generate test data inserts - 1GB

On 8/9/19 9:51 AM, Shital A wrote: On Fri, 9 Aug 2019, 21:25 Adrian Klaver, > wrote: On 8/9/19 8:14 AM, Shital A wrote: > > Hello, > > 4) What techniques have you tried? > Insert into with With statement, inserting 200 rows

Re: Generate test data inserts - 1GB

-- Adrian Klaver adrian.kla...@aklaver.com Thanks for the reply Adrian. Missed one requirement. Will these methods generate wal logs needed for replication? Actually the data is to check if replication catches up. Below is scenario :

Re: Generate test data inserts - 1GB

On Fri, 9 Aug 2019, 21:25 Adrian Klaver, wrote: > On 8/9/19 8:14 AM, Shital A wrote: > > > > > Hello, > > > > > 4) What techniques have you tried? > > Insert into with With statement, inserting 200 rows at a time. This > > takes 40 mins. > > > > To add to my previous post. If you already

Re: Generate test data inserts - 1GB

On 8/9/19 8:14 AM, Shital A wrote: Hello, 4) What techniques have you tried? Insert into with With statement, inserting 200 rows at a time. This takes 40 mins. To add to my previous post. If you already have data in a Postgres database then you could do: pg_dump -d db -t

Re: pg_wal fills up on big update query

flyway is an excellent tool, I use it too.  Just make a series of migrations. On 8/9/19 9:03 AM, Daniel Fink (PDF) wrote: Hi Rob, Thanks, I will try. It’s a bit of a  bummer though, because I just started to use flywaydb to manage migrations, and it wraps all migrations into a single

Re: Generate test data inserts - 1GB

On 8/9/19 8:14 AM, Shital A wrote: On Fri, 9 Aug 2019, 20:08 Adrian Klaver, > wrote: On 8/9/19 4:12 AM, Shital A wrote: > Hello > > Postgresql 9.6 > > Need to generate 1GB test data in very less time. I got some techniques

Re: Generate test data inserts - 1GB

On Fri, 9 Aug 2019, 20:08 Adrian Klaver, wrote: > On 8/9/19 4:12 AM, Shital A wrote: > > Hello > > > > Postgresql 9.6 > > > > Need to generate 1GB test data in very less time. I got some techniques > > online but they take around 40mins for 400GB. Any quicker way? > > 1) Postgres version? > > 2)

RE: pg_wal fills up on big update query

Hi Rob, Thanks, I will try. It’s a bit of a bummer though, because I just started to use flywaydb to manage migrations, and it wraps all migrations into a single transaction. So I have to do this outside of the tool. I will still try to evaluate if locking has any effect, to have a better

RE: pg_wal fills up on big update query

Hi Rob, Thanks, I will try. It’s a bit of a bummer though, because I just started to use flywaydb to manage migrations, and it wraps all migrations into a single transaction. So I have to do this outside of the tool. Best Regards, Daniel *From:* Rob Sargent

Re: Understanding PostgreSQL installer debug log

It looks like your encoding is correct. You are getting letters. If your encoding was just wrong. You would end up with a lot of strange characters. If this is tied to one client, it sounds like an encryption issue and mounting drives for logging that the client cant de-encrypt. Thanks, ~Ben On

Re: Updating 3-table dataset

On Fri, Aug 9, 2019 at 2:29 PM Moreno Andreo wrote: > > Hi all, > I don't know if that's the heat burning my brain but I can't find a > solution to what seemed a simple operation to me. > > I have 3 tables > create table t_all > { > id uuid, > ref_id uuid (FK to t_ana.id) > }; > create

Re: Understanding PostgreSQL installer debug log

On 8/9/19 4:25 AM, Ramesh Maddi wrote: Our product is certified along with PostgreSQL 9.6.6 only. We cannot use further version of PostgreSQL at this time in production until it is certified for our product( which is integrated may other components) and is officially released. Coming to

Re: Generate test data inserts - 1GB

On 8/9/19 4:12 AM, Shital A wrote: Hello Postgresql 9.6 Need to generate 1GB test data in very less time. I got some techniques online but they take around 40mins for 400GB. Any quicker way? 1) Postgres version? 2) Data going into single table or multiple tables? 3) What is the time frame

Re: PostgreSQL lock file

=?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= writes: > I have a task to create HA PostgreSQL cross datacenter cluster. I created a > test bed on VirtualBox and I simulate different failures and disastrous in > loops. And got one of funny bug of the Postgresql (11.4). One of the clusters >

Re: PostgreSQL 8.4 Tablespace Inconsistency

Harold Falkmeyer writes: > As an example of the seeming inconsistency, pg_class indicated that certain > tables and indexes were on reltablespace 0, which, as we understood, refers > to pg_default, which, coincidentally is listed with pg_tablespace with oid > 1663. That same pg_class object is

Re: ...

Le 09/08/2019 à 13:02, Luca Ferrari a écrit : > On Fri, Aug 9, 2019 at 12:10 PM Daniel Vos wrote: >> I use pgadmin 4.11 on windows 10 ( firefox, opera), >> with a table more 3000 rows >> if I use the contextual menu "view / edit data -> all rows", the grid >> result show 1000 rows. > Works

PostgreSQL lock file

Hi all. I have a task to create HA PostgreSQL cross datacenter cluster. I created a test bed on VirtualBox and I simulate different failures and disastrous in loops. And got one of funny bug of the Postgresql (11.4). One of the clusters has two instances of PostgreSQL on port 5433 and 5434.

Updating 3-table dataset

Hi all,     I don't know if that's the heat burning my brain but I can't find a solution to what seemed a simple operation to me. I have 3 tables create table t_all { id uuid, ref_id uuid (FK to t_ana.id) }; create table t_ana { id uuid, code text }; create table t_app { id uuid, code text 

Re: Recomended front ends?

For web/mobile applications we use Mojolicious, https://mojolicious.org witch work pretty well with Postgresql, is written in Perl and has plenty of nice features. Paolo Saudin Il giorno gio 8 ago 2019 alle ore 22:09 DiasCosta ha scritto: > Hi, > After many years of using Oracle Forms and

pglogical replication dies

Hi, I tried to setup upgrade using pglogical - from 9.5 to 11. I did set it up, and after subscription, initial data sync seems to work fine, but then replication dies. In logs on subscriber, every 3 minutes I see: db=,user= LOG: background worker "pglogical apply 114610049:2875150205" (PID

Re: Understanding PostgreSQL installer debug log

Our product is certified along with PostgreSQL 9.6.6 only. We cannot use further version of PostgreSQL at this time in production until it is certified for our product( which is integrated may other components) and is officially released. To elaborate actual issue with client in installing

Generate test data inserts - 1GB

Hello Postgresql 9.6 Need to generate 1GB test data in very less time. I got some techniques online but they take around 40mins for 400GB. Any quicker way? Thanks.

Re: ...

On Fri, Aug 9, 2019 at 12:10 PM Daniel Vos wrote: > I use pgadmin 4.11 on windows 10 ( firefox, opera), > with a table more 3000 rows > if I use the contextual menu "view / edit data -> all rows", the grid > result show 1000 rows. Works fine for me on linux/firefox 68. How can you say not all

Re: Understanding PostgreSQL installer debug log

Does the problem go away if you install pg11? Are the drives you are getting your logs from encrypted? Thanks, ~Ben On Fri, Aug 9, 2019, 3:17 AM Luca Ferrari wrote: > On Fri, Aug 9, 2019 at 8:46 AM Ramesh Maddi > wrote: > > ./postgresql-9.6.6-1-linux-x64.run --installer-language en >

...

Hi all, I use pgadmin 4.11 on windows 10 ( firefox, opera), with a table more 3000 rows if I use the contextual menu  "view / edit data -> all rows", the grid result show 1000 rows. if I refresh de query all rows showed

Re: Understanding PostgreSQL installer debug log

On Fri, Aug 9, 2019 at 11:01 AM Ramesh Maddi wrote: > Thanks in advance and appreciate your response. Please consider this as a > high priority for us. I don't think re-sending the

Understanding PostgreSQL installer debug log

Hi Team, Can you please help me to understand the PostgreSQL installer’s debug log. I am installing PostgreSQL in CentOS 7.6 system with PostgreSQL binary ( postgresql-9.6.6-1-linux-x64.run). I am using the below command to install it in unattended mode. ./postgresql-9.6.6-1-linux-x64.run

Re: Understanding PostgreSQL installer debug log

On Fri, Aug 9, 2019 at 8:46 AM Ramesh Maddi wrote: > ./postgresql-9.6.6-1-linux-x64.run --installer-language en --serviceaccount > postgres --servicename postgresqld --datadir "/home/postgres/" --prefix > "/home/postgres" --superpassword 1234 --serverport 5432 --debuglevel 4 > --debugtrace

Understanding PostgreSQL installer debug log

Hi Team, Can you please help me to understand the PostgreSQL installer’s debug log. I am installing PostgreSQL in CentOS 7.6 system with PostgreSQL binary ( postgresql-9.6.6-1-linux-x64.run). I am using the below command to install it in unattended mode. ./postgresql-9.6.6-1-linux-x64.run