>> > Some people have been doing it using a union view. There isn't actually
>> > a partition feature.
>>
>> Actually, there is. If found this example on pgsql-performance:
>>
>> >> CREATE TABLE super_foo ( partition NUMERIC, bar NUMERIC );
>> >> ANALYZE super_foo ;
>> >>
>> >> CREATE TABLE
in the
table partitions. (and in doing so is causing less disk IO)
BTW, internally, Oracle sees partitions as tables too. Even the "Union all"
system that MS SQL
Server uses works fine as long as the optimiser supports it to prune correctly.
Cheers,
Matt
--
Matt Casters <[EMAIL
u may have, I'll do my best to keep
pgsql-performance up to date on the results.
Best
regards,
Matt
_______
Matt Casters
i-Bridge bvba, http://www.kettle.be
Fonteinstraat 70, 9400 OKEGEM, Belgium
Tel. 054/25.01.37
GSM 0486/97.29.37
donderdag 20 januari 2005 21:26
Aan: [EMAIL PROTECTED]
CC: pgsql-performance@postgresql.org
Onderwerp: Re: [PERFORM]
Matt Casters wrote:
>
> Thanks Stephen,
>
> My main concern is to get as much read performance on the disks as
> possible on this given system. CPU is rarely a pro
-
Van: Stephen Frost [mailto:[EMAIL PROTECTED]
Verzonden: donderdag 20 januari 2005 15:26
Aan: Matt Casters
CC: pgsql-performance@postgresql.org
Onderwerp: Re: [PERFORM]
* Matt Casters ([EMAIL PROTECTED]) wrote:
> I have the go ahead of a customer to do some testing on Postgresql in
> a couple
#x27;t find any documents immediately, are there any fine manuals to
read on data
warehouse performance tuning on PostgreSQL?
Thanks in advance for any help you may have, I'll do my best to keep
pgsql-performance up to date
on the results.
Best regards,
Matt
--
Matt Casters <[EMAIL PROTECTE
this command like "vmstat 10". (ignore the first line)
Keep an eye on the "pi" and "po" parameters. (kilobytes paged in and out)
HTH,
Matt
--
Matt Casters <[EMAIL PROTECTED]>
i-Bridge bvba, http://www.kettle.be
Fonteinstraat 70,
