pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery limitations (size, number of UNIONs ...)
2+ messages / 2 participants
[nested] [flat]
* Query limitations (size, number of UNIONs ...)
@ 2005-06-03 06:35 Marc Mamin <m.mamin@gmx.net>
2005-06-03 13:27 ` Re: Query limitations (size, number of UNIONs ...) Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Mamin @ 2005-06-03 06:35 UTC (permalink / raw)
To: pgsql-performance
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 ++
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Query limitations (size, number of UNIONs ...)
2005-06-03 06:35 Query limitations (size, number of UNIONs ...) Marc Mamin <m.mamin@gmx.net>
@ 2005-06-03 13:27 ` Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 2+ messages in thread
From: Stephen Frost @ 2005-06-03 13:27 UTC (permalink / raw)
To: Marc Mamin <m.mamin@gmx.net>; +Cc: pgsql-performance
* Marc Mamin (m.mamin@gmx.net) wrote:
> I've just made a first test wich resulted in a query being 15KB big annd
> containing 63 UNION.
If the data is distinct from each other or you don't mind duplicate
records you might try using 'union all' instead of 'union'. Just a
thought.
Stephen
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-06-03 13:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-03 06:35 Query limitations (size, number of UNIONs ...) Marc Mamin <m.mamin@gmx.net>
2005-06-03 13:27 ` Stephen Frost <sfrost@snowman.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox