Viktor Rosenfeld writes:
> I've noticed that regular expressions which are anchored at the
> beginning of the text but have an optional part at the beginning
> (e.g. '^(ge)?kommen$') are not evaluated correctly if there is an
> index on the column.
Ugh. Yeah, that's a bug, and it looks a bit mes
On Sat, Jul 7, 2012 at 11:48 PM, Perry Smith wrote:
> The database is mostly static. I run through a very lengthy process to
> populate the database maybe once a month and then it is 99% read-only.
Do you run an ANALYZE on the table after populating it? Postgres needs
up-to-date statistics for
On Jul 6, 2012, at 7:56 PM, Steve Crawford wrote:
> On 07/06/2012 02:34 PM, Perry Smith wrote:
>> Hi Guys,
>>
>> This isn't a PostgreSQL specific question but just a SQL question. If this
>> is not an appropriate question for this list, please let me know.
>>
>> It is also, perhaps, a really
On Fri, Jul 6, 2012 at 8:51 PM, ach wrote:
> > My fastest postgresql servers have everything on one raid10, using 16 or
> > 20 15000 rpm SAS2 drives on a 1gb flash-backed cache controller.
>
> Thank you - that affirms what'd been my own growing supposition, and the
> plan
>
> > why?
>
> Really?
