On Thu, Jan 31, 2008 at 11:45:55AM +, Simon Riggs wrote:
> On Thu, 2008-01-31 at 10:22 +, Gregory Stark wrote:
> > "Decibel!" <[EMAIL PROTECTED]> writes:
> >
> > > CLUSTER isn't DDL. Most forms of ALTER TABLE are. And CREATE blah, etc.
> >
> > Fwiw I would call CLUSTER DDL. Note that it d
On Feb 1, 2008 3:56 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> > The situation seems pretty bad!!
>
> I think at least part of your problem is not understanding that a single
> transaction sees a frozen snapshot of pg_stat_activity.
>
>
It does! I assum
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
This page
http://linux-mm.org/OOM_Killer
Egad. Whoever thought *this* was a good idea should be taken out
and shot:
The independent memory size of any child (except a kernel thread) is added
to the score:
/*
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> This page
> http://linux-mm.org/OOM_Killer
Egad. Whoever thought *this* was a good idea should be taken out
and shot:
The independent memory size of any child (except a kernel thread) is added
to the score:
/*
* Processes which
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> The situation seems pretty bad!!
I think at least part of your problem is not understanding that a single
transaction sees a frozen snapshot of pg_stat_activity.
regards, tom lane
---(end of broadcast)-
--
From: "Gregory Stark" <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2008 10:31 PM
To: "Simon Riggs" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Subject: Re: [HACKERS] Backward reading
Is there any example of backward reading tuples into Pos
This page
http://linux-mm.org/OOM_Killer
says that you can hint the OOM killer to be more deferential towards
certain processes.
I am wondering if we can set the system up so that it skips postmaster,
bgwriter etc, and feels more preference towards normal backends (but
then, we would try to give
The situation seems pretty bad!!
Here are the steps to reproduce in 'PostgreSQL 8.3beta2 on
x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE Linux)':
session 1: begin;
session 1: update test set a = 112 where a = 112;
session 2: update test set a = 113 where a = 112; --waits
sessio
"Tom Lane" <[EMAIL PROTECTED]> writes:
> 1. DefineIndex() treats an omitted tablespace clause differently from
> explicitly specifying the tablespace that is the database's default:
> if you explicitly specify the space then you must have permissions on
> it, otherwise you don't need any. (This
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Fri, 2008-02-01 at 19:25 +0100, [EMAIL PROTECTED] wrote:
>> PostgreSQL allows "backward reading" tuples writing the tuple's length
>> after and before the tuple proper, in case a 'randomAccess' is
>> requested.
>>
>> Is there any example of backward
"Andrew Gilligan" <[EMAIL PROTECTED]> writes:
> test=> CREATE TABLE t2 (LIKE t1 INCLUDING INDEXES);
> ERROR: permission denied for tablespace pg_default
How annoying :-(. We could work around this particular manifestation
with a patch to make generateClonedIndexStmt() not set index->tableSpa
On Fri, 2008-02-01 at 19:25 +0100, [EMAIL PROTECTED] wrote:
> PostgreSQL allows "backward reading" tuples writing the tuple's length
> after and before the tuple proper, in case a 'randomAccess' is
> requested.
>
> Is there any example of backward reading tuples into PostgreSQL code?
Don't think
PostgreSQL allows "backward reading" tuples writing the tuple's length after
and before the tuple proper, in case a 'randomAccess' is requested.
Is there any example of backward reading tuples into PostgreSQL code?
Thanks.
>>> On Thu, Jan 31, 2008 at 10:19 PM, in message
<[EMAIL PROTECTED]>, Robert Treat
<[EMAIL PROTECTED]> wrote:
> On Thursday 31 January 2008 09:55, Kevin Grittner wrote:
>>
>> I can confirm that I have had performance tank because of boosting
>> the statistics target for selected columns. It appea
On Fri, 2008-02-01 at 15:42 +, Luke Porter wrote:
> All
>
> Is there an interest in developing bitemporal functionality in
> PostgreSQL
>
I am very interested in this topic, and I maintain the pgsql-temporal
project at:
http://pgfoundry.org/projects/temporal/
It's missing good docs and a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
> "Greg Stark" <[EMAIL PROTECTED]> writes:
>>> -> Index Scan using i_oa_2_00_dt_for on t_oa_2_00_dt dt (cost=0.00..5.31
>>> rows=1 width=8) (actual time=1.264..1.264 rows=0 loops=50)
>>> Index Cond: (dt.card_id = c.id)
>>> Filter: ((
"Greg Stark" <[EMAIL PROTECTED]> writes:
>> -> Index Scan using i_oa_2_00_dt_for on t_oa_2_00_dt dt (cost=0.00..5.31
>> rows=1 width=8) (actual time=1.264..1.264 rows=0 loops=50)
>> Index Cond: (dt.card_id = c.id)
>> Filter: ((_to >= 1500) AND (_from <= 1550))
>> Total runtime: 3399960.277 ms
>
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> I saw a strange behaviour on one of the production boxes. The
> pg_stat_activity shows a process as and yet 'waiting' !!! On top of
> it (understandably, since its IDLE), there are no entries for this pid in
> pg_locks!
Hmm, I can reproduce someth
On Feb 1, 2008, at 10:42 AM, Luke Porter wrote:
All
Is there an interest in developing bitemporal functionality in
PostgreSQL
Regards
Luke
I can only speak for myself, but- definitely! Based on the googling I
did on "bitemporal database", I kind of do this already with
PostgreSQL. S
> -> Index Scan using i_oa_2_00_dt_for on t_oa_2_00_dt dt
> (cost=0.00..5.31 rows=1 width=8) (actual time=1.264..1.264 rows=0 loops=50)
> Index Cond: (dt.card_id = c.id)
> Filter: ((_to >= 1500) AND (_from <= 1550))
> Total runtime: 3399960.277 ms
Also, are
Luke Porter <[EMAIL PROTECTED]> writes:
> Is there an interest in developing bitemporal functionality in PostgreSQL
Is that anything like the late, mostly unlamented "time travel" feature?
regards, tom lane
PS: in general, defining what you want with one word and assuming
All
Is there an interest in developing bitemporal functionality in PostgreSQL
Regards
Luke > From: [EMAIL PROTECTED]> Subject: Re: bitemporal functionality for
PostgreSQL> To: [EMAIL PROTECTED]> Date: Fri, 1 Feb 2008 10:08:03 -0500> > Luke
Porter wrote:> > > > Bruce> > > > I have a compell
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> On Thu, Jan 31, 2008 at 10:19 PM, in message
> <[EMAIL PROTECTED]>, Robert Treat
> <[EMAIL PROTECTED]> wrote:
>> Bad plans from boosting to 100 or less? Or something much higher?
> I boosted on a large number of columns based on domains. County
>
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>> It's evidently guessing wrong about the limit being satisfied early. The
>> non-indexed restrictions might be pruning out a lot more records than the
>> planner expects. Or possibly the table is just full of dead records.
> Here
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gregory Stark wrote:
> "Gaetano Mendola" <[EMAIL PROTECTED]> writes:
>
>> I don't get why a limit is going to change the query plan and most of all
>> decreasing
>> the performances.
>
> Until we see the explain analyze it won't be clear what exactl
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> I don't get why a limit is going to change the query plan and most of all
> decreasing
> the performances.
Until we see the explain analyze it won't be clear what exactly is going on.
But in theory a LIMIT can definitely change the plan because the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn van Oosterhout wrote:
> On Fri, Feb 01, 2008 at 12:08:56PM +0100, Gaetano Mendola wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Hi all,
>> I'm using 8.2.6 and I'm observing a trange behaviour using
>> offset and limits.
>
>
On Fri, Feb 01, 2008 at 12:08:56PM +0100, Gaetano Mendola wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi all,
> I'm using 8.2.6 and I'm observing a trange behaviour using
> offset and limits.
Please post EXPLAIN ANALYZE output so we can see what's actually taking
the time.
Have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm using 8.2.6 and I'm observing a trange behaviour using
offset and limits.
This are the two queries that are puzzling me:
explain SELECT c.id, tsk, lir, nctr, nctn, ncts, rvel,ecp, pvcp,
pvcc,pvcf,pvcl,ldcn,ogtd,sgti
FROM t_OA_2_0
Michael Meskes <[EMAIL PROTECTED]> writes:
> From: Mike Aubury <[EMAIL PROTECTED]>
> Any chance of adding this (or something similar) for the next RC?
> I don't like the idea of adding a feature albeit a very small one to 8.3
> at this point in time without even a small discussion. Mike explained
- Forwarded message from Mike Aubury <[EMAIL PROTECTED]> -
From: Mike Aubury <[EMAIL PROTECTED]>
To: Michael Meskes <[EMAIL PROTECTED]>
Subject: PGconn ?
Date: Wed, 30 Jan 2008 19:51:00 +
Any chance of adding this (or something similar) for the next RC?
ecpglib/connect.c :
31 matches
Mail list logo
