Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
Quick Links
Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites
Re: Querying 19million records very slowly
From:
PFC <lists(at)boutiquenumerique(dot)com>
To:
"Paul Ramsey" <pramsey(at)refractions(dot)net>, "Kjell Tore Fossbakk" <kjelltore(at)gmail(dot)com>
Cc:
pgsql-performance(at)postgresql(dot)org
Subject:
Re: Querying 19million records very slowly
Date:
2005-06-21 21:33:30
Message-ID:
op.ssqot4d4th1vuj@localhost
Views:
Raw Message
|
Whole Thread
|
Download mbox
|
Resend email
Thread:
2005-06-21 19:09:48 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
2005-06-21 19:59:22 from Paul Ramsey <pramsey(at)refractions(dot)net>
2005-06-21 21:33:30 from PFC <lists(at)boutiquenumerique(dot)com>
2005-06-22 07:45:22 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
2005-06-22 08:03:57 from Tobias Brox <tobias(at)nordicbet(dot)com>
2005-06-22 08:18:30 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
2005-06-22 08:39:21 from Tobias Brox <tobias(at)nordicbet(dot)com>
2005-06-22 08:55:35 from Michael Glaesemann <grzm(at)myrealbox(dot)com>
2005-06-22 09:10:42 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
2005-06-22 09:36:44 from Tobias Brox <tobias(at)nordicbet(dot)com>
2005-06-22 13:50:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-22 15:23:41 from Stefan Weiss <spaceman(at)foo(dot)at>
2005-06-22 14:20:13 from Paul Ramsey <pramsey(at)refractions(dot)net>
2005-06-22 14:41:54 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
2005-06-22 16:28:44 from Tobias Brox <tobias(at)nordicbet(dot)com>
2005-06-23 13:31:13 from Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
2005-06-23 15:31:12 from Tobias Brox <tobias(at)nordicbet(dot)com>
Lists:
pgsql-performance
use CURRENT_TIME which is a constant instead of now() which is not
considered constant... (I think)
In response to
Re: Querying 19million records very slowly
at 2005-06-21 19:59:22 from Paul Ramsey
Responses
Re: Querying 19million records very slowly
at 2005-06-22 07:45:22 from Kjell Tore Fossbakk
Browse pgsql-performance by date
From
Date
Subject
Next Message
William Yu
2005-06-21 21:53:52
Re: Trying to figure out pgbench
Previous Message
Tom Lane
2005-06-21 21:20:07
Re: Limit clause not using index