Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-08-30 Thread Christoph Berg
Re: Harry Ambrose 2017-08-25 > Hi All, > > Sorry to open this can of worms again. However, we are still struggling > with this issue across quite a large amount of our estate. Hi, we've just seen exactly this error on a customer database running 9.5.3 (postgresql95.x86_64 9.5.3-2PGDG.rhel6). L

[GENERAL] Veritas cluster management

2017-08-30 Thread Ron Johnson
Hi, For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatible config file changes), or must we bounce the database using "hares -offline" then "hares -online"? Thanks -- World Peace Through Nuclear Pacification -- Sent via pgsql-general mailing list

Re: [GENERAL] Veritas cluster management

2017-08-30 Thread Scott Mead
On Wed, Aug 30, 2017 at 9:43 AM, Ron Johnson wrote: > Hi, > > For any of you with those failover clusters, do you know if "pg_ctl > reload" works (for compatible config file changes), or must we bounce the > database using "hares -offline" then "hares -online"? > pg_ctl reload does work in this

Re: [GENERAL] Veritas cluster management

2017-08-30 Thread Ron Johnson
On 08/30/2017 08:48 AM, Scott Mead wrote: On Wed, Aug 30, 2017 at 9:43 AM, Ron Johnson > wrote: Hi, For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatible config file changes), or must we bounce the data

[GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

2017-08-30 Thread 유상지
I want to get help with Postgresql. I investigated that Postgresql could be rather fast in an environment using a secondary index. but It came up with different results on benckmark. The database I compared was mariadb, and the benchmark tool was sysbench 1.0.8 with the postgresql driver. Serve

Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

2017-08-30 Thread Melvin Davidson
On Wed, Aug 30, 2017 at 10:03 PM, 유상지 wrote: > > > I want to get help with Postgresql. > > I investigated that Postgresql could be rather fast in an environment > using a secondary index. but It came up with different results on benckmark. > > The database I compared was mariadb, and the benchmar

Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

2017-08-30 Thread Thomas Kellerer
유상지 schrieb am 31.08.2017 um 04:03: > Cluster secondary indexes were faster than those without cluster indexes in > pg, but slower than mariadb. There is no such thing as a "clustered index" in Postgres. The Postgres "cluster" command physically sorts the rows of a table according to the sort

[GENERAL] Table create time

2017-08-30 Thread hamann . w
Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer than a session) with conveniently short names. Also, is there a simple query to identify tables with