Hello everybody!
I'm trying to understand the the query planner's cost estimator.
I was not able to find anywhere the formulas that estimate the cost
of each operation that the optimizer produces.
I only found this for the sequential scan:
SEQ SCAN = ( cpu_tuple_cost * rows ) + ( number of pag
TE 'INSERT INTO ' || table_name ||' VALUES (($1).*)' USING NEW ;
RETURN NULL;
END;
$$
LANGUAGE plpgsql;
but it doesn't seem to work. It doesn't actually create new partition
tables.
The entries are inserted into "foo"
I attach a test .sql file that con
one note: I create a table of 100 entries in order to test it so I want 5
partition of 20 entries each.
(And not a table of 10 entries)
thanks again!
dafni
On Wed, Jun 26, 2013 at 4:47 PM, dafNi zaf wrote:
> Hello!
>
> I want to dynamically create partition tables that inher
!
Dafni
On Wed, Jun 26, 2013 at 5:32 PM, AI Rumman wrote:
> Yes, you missed the trigger part. And also you will get error like below
> during insert:
>
> INSERT INTO foo VALUES (99, 109, 109, 99, '2013-06-26 16:38:58.466');
> NOTICE: table_name = (foo_100_to_119
ment "INSERT INTO foo_1_to_21 VALUES (($1).*)"
PL/pgSQL function "foo_insert_trigger" line 19 at EXECUTE statement*
*
*
And also the tables that are created until the error occures are:
foo_0_to_20
foo_1_to_21
Thank you in advance!!
dafni
On Wed, Jun 26, 2013 at 5:55 PM, AI
running?
I am trying to avoid uploading the file all over again because it has
already been
running for 5 hours.
Thank you in advance!!
dafNi
i execute it periodically and sometimes there is a transaction and other
times it's idle:
INSERT INTO traces VALUES (.)
or
in transaction
So it's still running.. even thought there is some idle time.
Thank you very much!
On Thu, Aug 8, 2013 at 5:46 PM, David Johnston wrote
reply!
On Thu, Aug 8, 2013 at 5:46 PM, Alban Hertroys wrote:
> On 8 August 2013 16:33, dafNi zaf wrote:
>
>>
>> Hello to everybody,
>>
>> I started to upload (via phpPgAdmin) to a local server a huge file (20GB)
>> in
>> order to fill up a database.
>
you for the reply!
dafNi
On Thu, Aug 8, 2013 at 5:57 PM, Ian Lawrence Barwick wrote:
> 2013/8/8 dafNi zaf :
> > Hello to everybody,
> >
> > I started to upload (via phpPgAdmin) to a local server a huge file
> (20GB) in
> > order to fill up a database.
>
>
