Hi all. I dont understand why this is happening. Simple hardcoded
function, looking for an id who doesn't exists:
REATE FUNCTION pp()
returns setof public.pp
as
$$
select * from public.pp where id=99;
$$ language sql;
So there is no id=9 in table public.pp
test=# SELECT * from pp();
id|
There is no partitioning by size that I know of but at:
http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html
there is very good documentation on the topic.
As of this last weekend I had myself to do some testing with
partitioning in Postgres 8.4. I had 7000 items. For each of them
I'm trying to figure out the logic behind the date parameters though. I
don't have to worry at all about partition size.
Joshua Gooding
On 6/24/2010 3:37 PM, Little, Douglas wrote:
I don't know how you would partition by size.
Date is a good candidate, and roughly wouldn't you have the same
I don't know how you would partition by size.
Date is a good candidate, and roughly wouldn't you have the same number of
tx's/day
You'll only benefit query performance if you include the partitioning column in
the where clause.
If you have a surrogate pk, you could also use this to partition. U
I think I replied to the individual and not to the list before
As of right now size doesn't matter, I need to partition it via a date.
10 partitions, 10 weeks worth of data.
I was thinking of partitioning it off every 32GB of data, but that is
not exactly what I am looking to do.
Joshu
> regression=# SELECT * from test order by ascii(data);
That is what I was looking for. Thanks to all.
--
Bryan White
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On 2010-06-24, Joshua Gooding wrote:
> Right now I am in the process of migrating an Oracle DB over to Postgres
> 8.4.3. The table is partitioned by size. Is there anyway to partition
> the new postgres table by size? I created some partitions for the new
> table, but I didn't give postgres
Right now I am in the process of migrating an Oracle DB over to Postgres
8.4.3. The table is partitioned by size. Is there anyway to partition
the new postgres table by size? I created some partitions for the new
table, but I didn't give postgres any rules to partition by, so I have
250M tes
