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.
>
>
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.
>
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:
> dafNi w
Hello to everybody,
I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in
order to fill up a database.
The uploding completed and the transactions started. But unfortunately, my
browser crashed/freezed in the middle of the transactions.
I wanted to know, given that the uplo
lt;= 22 ))
> INHERITS (foo)
> INSERT 0 0
> postgres=# \d
> List of relations
> Schema | Name | Type | Owner
> +---+---+--
> public | foo | table | postgres
> public | foo_1_to_21 | table | postgres
> pu
ristian Cruz <
> danielcrist...@gmail.com> wrote:
>
>> You forgot to set the trigger on foo:
>>
>> CREATE TRIGGER foo_insert
>> BEFORE INSERT ON foo
>> FOR EACH ROW EXECUTE PROCEDURE foo_insert_trigger();
>>
>>
>>
>> 2013/
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
Hello!
I want to dynamically create partition tables that inherit a main table
called "foo".
The creation must occur when needed.
For example, lets say that I want to insert 10 entries and I want 5
partition
tables (with 2 entries each).
So, first I need a partition for the first 2 e
