Dear mailing list.
My current application make use of partitioning by creating a new child table
which holds transaction records for every month. I've notice that after a
couple of months depending on the hardware at some of our clients the inserts
become very slow. The reason memory. I don't w
On 08/18/12 1:05 AM, Bartel Viljoen wrote:
Dear mailing list.
My current application make use of partitioning by creating a new
child table which holds transaction records for every month. I’ve
notice that after a couple of months depending on the hardware at some
of our clients the inserts
On 08/18/2012 06:49 AM, Merlin Moncure wrote:
For various reasons, this often goes the wrong way. Views are often
the right way to go.
Indeed. I've had queries speed up *hundreds* of times when I convert a
function the planner didn't seem to want to inline into a view it can
push conditions
On 08/18/2012 04:05 PM, Bartel Viljoen wrote:
Dear mailing list.
My current application make use of partitioning by creating a new child
table which holds transaction records for every month. I’ve notice that
after a couple of months depending on the hardware at some of our
clients the inserts b
On Sat, Aug 18, 2012 at 1:05 AM, Bartel Viljoen wrote:
> Dear mailing list.
>
> ** **
>
> My current application make use of partitioning by creating a new child
> table which holds transaction records for every month. I’ve notice that
> after a couple of months depending on the hardware at s
Hi,
I have the following table:
dwh=> \d events
Table "public.events"
Column |Type | Modifiers
--+-+---
datetime | timestamp without time zone |
request_duration | integer
> > In fact, shouldn't reasonably well-designed data models at least
> > mostly follow SER principles? In that case, they could be displayed
> > essentially
> as a
> > tree.
>
> No - and what the heck are "SER principles"?
Structured Entity Relationship model.
It means that the dependency graph
Raghavendra writes:
>> I tried your code in Postgres 8.2:
> 8.2 ?, Seems you have tested it in very Old version.
Indeed. The example works OK for me too, in 8.2.23 which is the last of
that release branch.
regards, tom lane
--
Sent via pgsql-general mailing list (pgs
Craig Ringer writes:
> On 08/18/2012 04:05 PM, Bartel Viljoen wrote:
>> My current application make use of partitioning by creating a new child
>> table which holds transaction records for every month. Ive notice that
>> after a couple of months depending on the hardware at some of our
>> clients
On Sat, Aug 18, 2012 at 1:05 AM, Bartel Viljoen wrote:
> Dear mailing list.
>
> ** **
>
> My current application make use of partitioning by creating a new child
> table which holds transaction records for every month. I’ve notice that
> after a couple of months depending on the hardware at s
On 2012-08-16, Wells Oliver wrote:
> --0023543336c685451c04c7683ffb
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hey folks, a question. We have a table that's getting large (6 million rows
> right now, but hey, no end in sight). It's wide-ish, too, 98 columns.
>
> The problem is that each of
On 18/08/12 04:33, David Johnston wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Wolfgang Keller
Sent: Friday, August 17, 2012 9:08 AM
To: pgsql-general@postgresql.org
Subject: Messy data models (Re: [GENERAL]
On 18/08/12 20:05, Bartel Viljoen wrote:
[...]
I'm in the design faze of a new GUI and DB layout, what are my options.
[...]
I think you meant phase!
(Spell checkers can be quite stupid!)
Cheers,
Gavin
On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower wrote:
> On 18/08/12 20:05, Bartel Viljoen wrote:
>
> [...]
>
>
> I’m in the design faze of a new GUI and DB layout, what are my options.
>
> [...]
> I think you meant phase!
> (Spell checkers can be quite stupid!)
>
Could be worse See the
14 matches
Mail list logo