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

[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.

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

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

[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

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