On 02/06/16 20:01, rverghese wrote:
> We are looking to move from one large table to partitioned tables. Since the
> inserts and updates are made to the master table and then inserted into the
> appropriate partitioned table based on the trigger rules, the affected_rows
> returned to the client (PH
On Thu, 2016-06-02 at 11:01 -0700, rverghese wrote:
> We are looking to move from one large table to partitioned tables.
> Since the
> inserts and updates are made to the master table and then inserted
> into the
> appropriate partitioned table based on the trigger rules, the
> affected_rows
> retu
We are looking to move from one large table to partitioned tables. Since the
inserts and updates are made to the master table and then inserted into the
appropriate partitioned table based on the trigger rules, the affected_rows
returned to the client (PHP in this case) is always 0. We have been us
Hi all,
I've been using Postgresql (9.3) for a while, but I'm new to
partitioned tables.
1. I have noticed that when the partition trigger function returns
NULL (to stop operation on the parent table), the operation always
reports no (zero) rows affected - even when rows have been affected.
Th
On Fri, Oct 16, 2009 at 3:31 PM, marcin mank wrote:
> On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
> wrote:
>
>> The basic problem I have is that I have some tables that are
>> potentially very long (100,000's to millions of rows) and very skinny,
>
>> and I end up with maybe a total of 12 b
On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
wrote:
> The basic problem I have is that I have some tables that are
> potentially very long (100,000's to millions of rows) and very skinny,
> and I end up with maybe a total of 12 bits of data in each row.
Are You aware that there are some 20
I just realized that my replies to my previous question on sparse
arrays went off list due to the way this list server is set up
(sigh). It has occurred to me that for my problem, one possible
solution is columnar indexes and that, in a way, partitioned tables in
Postgres might give me somewhat t
On Thursday 28 August 2008, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> Ow Mun Heng wrote:
> > I posed this question to the Slony List as well, but no response yet.
>
> It's actually in the Slony docs:
> http://www.slony.info/documentation/partitioning.html
>
> I haven't actually used it in produc
Ow Mun Heng wrote:
> I posed this question to the Slony List as well, but no response yet.
It's actually in the Slony docs:
http://www.slony.info/documentation/partitioning.html
I haven't actually used it in production myself, though :-)
//Magnus
--
Sent via pgsql-general mailing list (pgsql-g
I posed this question to the Slony List as well, but no response yet.
I'll post it here as well, to elicit some responses, as there's a larger
community of people using PG+Slony who may also be on slony-list.
The question that I have is, I'm trying to determine if there's a
possibility that I can
On 12:54 pm 07/31/08 "Mike Gould" <[EMAIL PROTECTED]> wrote:
> 1. Is the planner/optimizer intelligent enough to know when we are
> not doing a query based on location?
In short yes.
If the DB doesn't see the condition by which your tables are partitioned it
will search all the partitions.
> 2.
I have several tables that we have partitioned by physical location. This
seems to give us the best overall performance when doing location specific
queries. I have a few questions.
1. Is the planner/optimizer intelligent enough to know when we are not doing a
query based on location? For ex
Hi,
What need to be taken care of when replicating data from partitioned
tables?
I have several master tables that are inherited by date either daily,
weekly and monthly.
How to automate addition of newly created child tables into Slony
cluster?
Thanks,
Goboxe
---(end o
Thanks Chris.
How do I use *.sh & *.ik files?
Goboxe
On Dec 19, 12:17 am, Chris Browne <[EMAIL PROTECTED]> wrote:
> Goboxe <[EMAIL PROTECTED]> writes:
> > What need to be taken care of when replicating data from partitioned
> > tables?
>
> > I have several master tables that are inherited by dat
Goboxe <[EMAIL PROTECTED]> writes:
> Thanks Chris.
>
> How do I use *.sh & *.ik files?
The "*.sh" files are shell scripts that should run with any Bourne
shell; the *specific* intent is that they be invoked by the test
control script, "run_test.sh".
The "*.ik" files are (mostly) bodies of Slonik
Goboxe <[EMAIL PROTECTED]> writes:
> What need to be taken care of when replicating data from partitioned
> tables?
>
> I have several master tables that are inherited by date either daily,
> weekly and monthly.
>
> How to automate addition of newly created child tables into Slony
> cluster?
There
On 10/6/07, Goboxe <[EMAIL PROTECTED]> wrote:
> Josh,
>
> Thanks for sharing a very good info on partitioning.
>
Don't thank me -- this comes from Robert Treat. I'm just the messenger :)
-Josh/eggyknap
---(end of broadcast)---
TIP 2: Don't 'kill -9
Josh,
Thanks for sharing a very good info on partitioning.
On Oct 5, 10:08 pm, [EMAIL PROTECTED] ("Josh Tolley") wrote:
> On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I have two questions on the above:
>
> > 1. I found in some postings recommended to use triggers instead of
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
> On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
>
>> On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote:
>>> On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
Hi,
I have two questions on the above:
1. I found
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote:
On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote:
> On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have two questions on the above:
> >
> > 1. I found in some postings recommended to use triggers instead of
> > rules. Is this documented somewhere?
>
> A howto is available at
> htt
On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two questions on the above:
>
> 1. I found in some postings recommended to use triggers instead of
> rules. Is this documented somewhere?
A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/e
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
2. When using trigger, any examples on how to update the trigger
dynamically when tables are added or deleted from the partitioned?
Thanks,
Amin
-
23 matches
Mail list logo
