On Wed, Feb 5, 2014 at 11:47 AM, Pweaver (Paul Weaver)
wrote:
>
> On Wed, Feb 5, 2014 at 9:52 AM, Jeff Janes wrote:
>
>> On Monday, February 3, 2014, Pweaver (Paul Weaver)
>> wrote:
>>
>>> We have been running into a (live lock?) issue on our production
>>> Postgres instance causing queries refe
On Tue, Feb 11, 2014 at 8:29 PM, Jeff Janes wrote:
> On Fri, Feb 7, 2014 at 10:47 AM, Claudio Freire
> wrote:
>>
>> Hello list.
>>
>> I know all the theory about vacuuming. I've got log tables that get
>> periodically pruned. The pruning is... quirky, though. It's not so
>> much deleting data, as
On Fri, Feb 7, 2014 at 10:47 AM, Claudio Freire wrote:
> Hello list.
>
> I know all the theory about vacuuming. I've got log tables that get
> periodically pruned. The pruning is... quirky, though. It's not so
> much deleting data, as summarizing many (thousands) of rows into one
> single row. For
On Tue, Feb 11, 2014 at 5:54 PM, Eildert Groeneveld
wrote:
> Dear All
>
> this probably not the best list to post this question:
>
> I use cascading deletes but would like to first inform the user what she
> is about to do.
> Something like : explain delete from PANEL where panel_id=21;
> -- you a
Dear All
this probably not the best list to post this question:
I use cascading deletes but would like to first inform the user what she
is about to do.
Something like : explain delete from PANEL where panel_id=21;
-- you are about to delete 32144 records in tables abc aaa wewew
This is clearly
=?UTF-8?Q?S=C3=A9bastien_Lorion?= writes:
> That's interesting .. Does PostgreSQL always use the NUMERIC data type for
> constants in absence of cast ?
If they're not integers, yes, that's the initial assumption.
regards, tom lane
--
Sent via pgsql-performance mailing
On Mon, Feb 10, 2014 at 3:03 PM, Heikki Linnakangas wrote:
> On 02/10/2014 09:52 PM, M Putz wrote:
>
>>
>> Hello,
>>
>> While analyzing performance, we encountered the following phenomenon,
>>
>> SELECT sum(pow(.5*generate_series,.5))
>> FROM generate_series(1,100);
>>
>> is much much
