On Sat, May 4, 2013 at 5:53 AM, Yang Zhang wrote:
> Yeah, I know that indexes for unlogged tables are unlogged. I was
> just wondering if you could do this for logged tables. (Safely, such
> that on crash recovery WAL replay won't throw up, these can be omitted
> from base backups, etc.)
>
No,
Looking to start collecting what memory usage I can via logging with an eye
towards establishing typical usage profiles for different users (i.e. app,
reporting, etc.) and hopefully later gaining the ability to kill extreme
outliers when they hit.
So, would the temp file size logged via log_tem
On Mon, May 6, 2013 at 11:19 AM, Carlo Stonebanks
wrote:
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jasen Betts
> Sent: May 4, 2013 7:44 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Simple
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jasen Betts
Sent: May 4, 2013 7:44 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Simple SQL INSERT to avoid duplication failed: why?
On 2013-05-01, Carlo Ston
On Sat, May 4, 2013 at 6:40 PM, Karel Riveron Escobar
wrote:
>
> Hello everyone,
>
> I have a problem with Pl/PgSQL function. I need to pass it as parameter an
> associative array. I have no idea how to do that. Can somebody help me?
>
> To be more specific, I have an associative array in PHP. Som
On 2013-05-06, Tim Uckun wrote:
> --047d7b2e4ea07402b004dc034a3b
> Content-Type: text/plain; charset=UTF-8
>
> Say I have a select like this.
>
> SELECT * FROM table where field = X OR field = Y limit 1
>
> And I have two records one that matches X and one that matches Y will I
> always get X beca
On Mon, May 06, 2013 at 02:16:38PM +1200, Tim Uckun wrote:
> Say I have a select like this.
>
> SELECT * FROM table where field = X OR field = Y limit 1
>
> And I have two records one that matches X and one that matches Y will I
> always get X because the evaluation will stop after the first clau
