Postgres Pro
Downloads
Home   >   mailing lists

Query limitations (size, number of UNIONs ...) - Mailing list pgsql-performance

From Marc Mamin
Subject Query limitations (size, number of UNIONs ...)
Date
Msg-id 30384.1117780528@www35.gmx.net
Whole thread Raw
In response to Re: Adaptec/LSI/?? RAID (what about JBOD?)  (mudfoot@rawbw.com)
Responses Re: Query limitations (size, number of UNIONs ...)  (Stephen Frost <sfrost@snowman.net>)
List pgsql-performance
Tree view 
Hello,


I've split my data in daily tables to keep them in an acceptable size.

Now I have quite complex queries which may be very long if I need to query a
large number of daily tables.


I've just made a first test wich resulted in a query being 15KB big annd
containing 63 UNION.

The Query plan in PGAdmin is about 100KB big with 800 lines :-)


The performance is not such bad, but I'm wondering if there are some
POSTGRES limitations I should take care of with this strategy.


Thanks,

Marc

--
Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis
++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
Next
From: "Martin Fandel"
Date:
Subject: Filesystem