On Feb 1, 2011, at 10:31 PM, NEVIN ALEX wrote:
> Hi,
> I am Nevin Alex and I am using postgresql database for a year . But I
> have’nt used table partitions: Please help me to do it in a better way. I got
> it from the documentation that it is an inheritance capability and the
> Trigger
Hi,
I am Nevin Alex and I am using postgresql database for a year . But I
have’nt used table partitions: Please help me to do it in a better way. I got
it from the documentation that it is an inheritance capability and the Trigger
working but for dynamic data how can I implement that.
T
Yes, I will do in this way
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Enrico Weigelt
Sent: Friday, April 08, 2005 7:18 AM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Table PARTITION
* Richard Huxton wrote:
> S
* Richard Huxton wrote:
> Sean Davis wrote:
> >This is a totally selfish question, but IF someone has a few minutes,
> >could he/she explain why table partitioning is such an important tool?
>
> Say you have a large log-table, you could partition it by month. If most
> queries only search the l
Sean Davis wrote:
This is a totally selfish question, but IF someone has a few minutes,
could he/she explain why table partitioning is such an important tool?
Say you have a large log-table, you could partition it by month. If most
queries only search the last month or two, a lot of your partitio
Dinesh Pandey wrote:
Hi Richard,
I am using postgres 8.0.1. It allows us to create TABLESPACE but I don't
know how to create PARTITION in postgres.
Can you pls tell me little more.
You can't I'm afraid. You can use inheritance / a view unioning tables
to do something similar though. Check the m
This is a totally selfish question, but IF someone has a few minutes,
could he/she explain why table partitioning is such an important tool?
Thanks,
Sean
On Apr 7, 2005, at 8:06 AM, Richard Huxton wrote:
Dinesh Pandey wrote:
How can we create oracle's table with partition in Postgres. (How to
cr
5:36 PM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL'
Subject: Re: [SQL] Table PARTITION
Dinesh Pandey wrote:
> How can we create oracle's table with partition in Postgres. (How to
> create Table partion in postgres)
>
> CREATE TABLE invoices
> (invoice_noNUMBER NOT
Dinesh Pandey wrote:
How can we create oracle's table with partition in Postgres. (How to create
Table partion in postgres)
CREATE TABLE invoices
(invoice_noNUMBER NOT NULL,
invoice_date DATE NOT NULL,
comments VARCHAR2(500))
PARTITION BY RANGE (invoice_date)
(PARTITION invoices_q1
Title: Table PARTITION
How can we create oracle's table with partition in Postgres. (How to create Table partion in postgres)
CREATE TABLE invoices
(invoice_no NUMBER NOT NULL,
invoice_date DATE NOT NULL,
comments VARCHAR2(500))
PARTITION BY RANGE (invoice_date)
(PARTIT
10 matches
Mail list logo
