Title: Nachricht
What
EXACTLY do you mean under "query optimizertechnic " ?
Regards. Milen
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of shyju c.kSent: Thursday, June 15, 2006 10:11
PMTo: pgsql-general@postgresql.orgSubject: [GENE
Hi Listers,
I am playing a little bit more with partioning (constraint exclusion) in tha
last days.
I have tried with one-level partioning (one parent table + 2 inherited tables).
Worls like a charm.
I want to go further, I and wanted to test sub-partiotioning (grandchild
tables of the master
Thanks Tom,
OFFSET is even better solution for me .
Regards. Milen
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 3:57 PM
To: Milen Kulev
Cc: 'Jim C. Nasby'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Partitioning...
&q
Aha !!!
Thanks Jim, the "trick" worked for me !
Regards. Milen
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 1:09 AM
To: Tom Lane
Cc: Milen Kulev; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Partitioning...
On Mon, Ju
Aha !
Obviosly that is the reason for working sometimes properly ans sometimes not ...
Thanks !
Regards. Milen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Tuesday, June 13, 2006 12:58 AM
To: Milen Kulev
Cc: pgsql-general@postgresql.org
f Tom Lane
Sent: Tuesday, June 13, 2006 12:18 AM
To: Milen Kulev
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Partitioning...
"Milen Kulev" <[EMAIL PROTECTED]> writes:
> But When I issue:
> insert into part(id1, id2, filler)
> select
> round( (random()*20
,
'TTTESTZZZ'
from generate_series(0,10);
Regards. Milen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Tuesday, June 13, 2006 12:18 AM
To: Milen Kulev
Cc: pgsql-general@postgresql.org
Subject: Re
Hi listers,
I am trying to learn PG partioning (constaraint exclustion).
I have created pretty simple table (all the code is below), but when I try to
populate
The table with data, the RULE system is not working as expected (e.g. as I have
expected).
The code:
---
all)?
If it were the case I simply would have used the plain text backup (pg_dump
-Fp and then psql)...
Regards. Milen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Sunday, April 09, 2006 9:45 PM
To: Milen Kulev
Cc: pgsql-gene
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Sunday, April 09, 2006 8:24 PM
To: Milen Kulev
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] "Pg_restore -C" is not creating a database ( Was Create
database bug in 8.1.3 ? )
"Milen Kulev&quo
db1; <--!!!
false
2615
2200
public
SCHEMA
CREATE SCHEMA public;
DROP SCHEMA public;
Regards. Milen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Sunday, April 09, 2006 6:01 PM
To: Milen Kulev
Cc: pgsql-general@postgresql.org
McNaught
Sent: Sunday, April 09, 2006 4:05 PM
To: Milen Kulev
Cc: 'William ZHANG'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Create database bug in 8.1.3 ? -> solved
"Milen Kulev" <[EMAIL PROTECTED]> writes:
> Hi Wiliam,
> Than you very much f
Hi Listers,
My saga contunues ;(
I can not get pg_restore working as expected (as described in the
documentation).
My case : I have a DB, that I have archived with
pg_dump -C -Fc -d testdb1 > tdb1b.bak
Then I am dropping the database testdb1 ( with DROP DATABASE testdb1; ) I want
to recov
Hi Wiliam,
Than you very much for your prompt reply.
I can not understand why pg_dump, pg_dumpall have hard-coded "template0" ?
In my case I haven't modified template1 DB ( e.g. template0 equals template1
DB), so it
Doesn't mater for me, bit I am still wondering ... ;( .
The documentation is s
Hi Listers,
I have the following problem (OS= RHELU2 , PG version= 8.1.3) when I try to
Create a database :
postgres=# CREATE DATABASE world3 TEMPLATE=template1 ENCODING='UTF8'
TABLESPACE=tbs1 ;
CREATE DATABASE
Then I am backup-ing the database (a small toy DB) with pg_dumpall:
pg_dumpa
15 matches
Mail list logo
