r d-3 wrote
> Hi,
>
> this is with 9.2.4_PGDG / FC18 / 64bit upgraded from 9.1.8 via
> dump/restore, settings kept for the most part.
>
> Table has 1.5M records, the varchar(100) field in question has a *
> varchar_ops* and a *varchar_pattern_ops* btree index.
>
> 3 Cases:
>
>- "MYFIELD" li
Hi,
this is with 9.2.4_PGDG / FC18 / 64bit upgraded from 9.1.8 via
dump/restore, settings kept for the most part.
Table has 1.5M records, the varchar(100) field in question has a *
varchar_ops* and a *varchar_pattern_ops* btree index.
3 Cases:
- "MYFIELD" like 'BLA BLA *%*': *OK, about 7 mse
On Sat, Apr 6, 2013 at 1:24 AM, Heikki Linnakangas
wrote:
>
> Incidentally, I bumped into another custom backup script just a few weeks
> back that also excluded backup_label. I don't know what the author was
> thinking when he wrote that, but it seems to be a surprisingly common
> mistake. Maybe
On 06.04.2013 01:02, Jeff Janes wrote:
On Fri, Apr 5, 2013 at 12:27 PM, wrote:
I use a custom base backup script to call pg_start/stop_backup() and make
the backup with rsync.
The restore_command in recovery.conf is never called by PG 9.2.4 during
startup. I confirmed this by adding a "touch /
