I can recommend "SQL Queries for Mere Mortals: A Hands-on Guide to Data
Manipulation in SQL" as a good general SQL book.
From: Scott Ribe
To: Postgresql General
Sent: Wednesday, 23 January 2013, 22:56
Subject: [GENERAL] seeking SQL book recommendation
is a shame
because it's a very useful tool.
Cheers,
James
From: Tom Lane
To: James Cowell
Cc: "pgsql-general@postgresql.org" ; Jeff Janes
; "w...@wdicc.com"
Sent: Tuesday, 8 January 2013, 18:02
Subject: Re: [GENERAL] [So
t.
Cheers,
James
____
From: James Cowell
To: James Cowell ; "pgsql-general@postgresql.org"
Cc: Jeff Janes
Sent: Thursday, 3 January 2013, 16:12
Subject: Re: [GENERAL] Corrupt indexes on slave when using pg_bulkload on master
Hi Jeff (and group)
Wa
would really like to understand why a load of 10 sequential rows with
pg_bulkload produces a corrupt index on node 2 though, it just doesn't make
sense to me.
Thanks and Happy New Year!
James
____
From: James Cowell
To: "pgsql-general@postgresql.org&qu
just
needs a "set enable_seqscan=false" prior to running the selects on the slave.
Cheers,
James
____
From: James Cowell
To: Jeff Janes
Cc: "pgsql-general@postgresql.org"
Sent: Monday, 17 December 2012, 20:42
Subject: Re: [GENERAL] Corr
to constraint violation as one table is new
rows only.
I will try and put together a new reproduction case this week.
Cheers,
James
From: James Cowell
To: Jeff Janes
Cc: "pgsql-general@postgresql.org"
Sent: Thursday, 13 December 2
've attached a text file with details for table, load config file etc, is that
everything you would need?
Cheers,
James
____
From: Jeff Janes
To: James Cowell
Cc: "pgsql-general@postgresql.org"
Sent: Monday, 10 December 2012, 16:53
Subject: Re:
licated without issue.
Thanks,
James
____
From: James Cowell
To: 'Jeff Janes'
Cc: pgsql-general@postgresql.org
Sent: Wednesday, 5 December 2012, 18:56
Subject: Re: [GENERAL] Corrupt indexes on slave when using pg_bulkload on master
Hi Jeff,
Than
en't using
pg_bulkload, for example:
http://postgresql.1045698.n5.nabble.com/BUG-7562-could-not-read-block-0-in-f
ile-quot-base-16385-16585-quot-read-only-0-of-8192-bytes-td5724738.html
Cheers,
James
-Original Message-
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: 05 Decemb
I'm using pg_bulkload to load large amounts of CSV data into a postgres
database hourly.
This database is replicated to a second node.
Whenever a bulk load happens the indexes on the updated tables on the secondary
node corrupt and are unusable until a reindex is run on the primary node. I
10 matches
Mail list logo
