nts (avg/stddev): 1./0.00
execution time (avg/stddev): 0.1325/0.00
--
Best regards,
Hannes Dorbath
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
_birthday;
?column?| next_birthday
+-
2008-05-04 a Sunday| 2009-05-04 00:00:00 a Monday
?
Sorry, I think I phrased the question badly. What I'm after basically is:
http://www.depesz.com/index.php/2007/10/26/who-has-birthday-tomorrow/
es me some headaches.
Is there any best practice to do that in PostgreSQL?
--
Best regards,
Hannes Dorbath
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
#x27;d say caching is better done on a higher level -- like HTML fragments
or what ever you generate from those queries..
Just my two cent.
--
Best regards,
Hannes Dorbath
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscrip
are AVG from 3 runs each. DROP/CREATE DATABASE and CHECKPOINT;
before each run.
--
Best regards,
Hannes Dorbath
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
much that
further discussion seems pointless. I'll repost when I really have
reproducible values and followed Greg Smith's advice.
--
Best regards,
Hannes Dorbath
---(end of broadcast)---
TIP 6: explain analyze is your friend
e. Synthetic load like
pgbench -i -s 10 -U pgsql -d bench && pgbench -t 1000 -c 100 -U pgsql -d
bench
or the same with scale 100.
Maybe it's just my test box.. single SATA-II drive, XFS on top of LVM.
I'll retry without LVM once I have another drive.. I've seen LVM mess
is really nothing to use on any serious disc array.
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
ve fsync=on and
> full_page_writes=on which is the default then you shouldn't have any data
> integrity issues.
That was my point, controllers without BBU usually leave drive caches
turned on, as with drive caches off performance would be unbearable bad.
--
Best regards,
Hannes Dorbath
roller.
And before you move that box in production, check:
Is my hardware and software setup fsync/fua clean?
Is my backup plan working?
--
Best regards,
Hannes Dorbath
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
th some outdated desktop hardware. If that's not enough read up
on things like
http://blog.lighttpd.net/articles/2006/11/27/comet-meets-mod_mailbox
--
Best regards,
Hannes Dorbath
---(end of broadcast)---
TIP 6: explain analyze is your friend
GFS2, OFCS2, lustre, CXFS, GPFS, Veritas and what else there is..
..has someone experience with any of those? Is it bearable to run PG on
them from a performance point of view? I guess not, but any positive
reports?
Thanks
--
Regards,
Hannes Dorbath
---(end of
On 06.11.2006 15:13, Heikki Linnakangas wrote:
Hannes Dorbath wrote:
Though it should only have to join a few rows it seems to scan all rows.
What makes you think that's the case?
Sorry, not all rows, but 80753. It's not clear to me why this number is
so high with LIMIT 10.
anks in advance!
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
limited by the disc subsystem.
Can someone enlighten me what this site is about?
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 6: explain analyze is your friend
outage, neither that the drive
does not corrupt something during the involuntary shutdown / power
irregularities. (This is theoretical as any server will be UPS backed)
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 3: Have
s
On 04.04.2005 17:18, Hannes Dorbath wrote:
Mhh. I have no clue about the internals of PostgreSQL and query planing,
but to me as user this should really be a thing the optimizer has to
work out..
On 03.04.2005 10:01, PFC wrote:
Noticed this problem,too.
You can always make the calcula
returning function so it'll behave like a table, but that's ugly.
On Mon, 28 Mar 2005 16:14:44 +0200, Hannes Dorbath
<[EMAIL PROTECTED]> wrote:
hm, a few days and not a single reply :|
any more information needed? test data? simplified test case? anything?
thanks
Hannes Dorbath wrot
hm, a few days and not a single reply :|
any more information needed? test data? simplified test case? anything?
thanks
Hannes Dorbath wrote:
The query and the corresponding EXPLAIN is at
http://hannes.imos.net/query.txt
I'd like to use the column q.replaced_serials for multiple calculatio
Thank you very much for your reply. I'll try to modify it.
Josh Berkus wrote:
Hannes,
The query and the corresponding EXPLAIN is at
http://hannes.imos.net/query.txt
The problem is that you're using a complex corellated sub-select in the SELECT
clause:
SELECT
d.delivery_id,
da.ar
und out that PG behaves the same in case q
is a view. This makes me wonder how efficient the optimizer can work
with views - or even worse - nested views.
Tested and reproduced on PG 7.4.1 linux and 8.0.0 win32.
Thanks in advance,
Hannes Dorbath
---(end of broadcast)-
21 matches
Mail list logo
