On 7/28/05, Chris Travers <[EMAIL PROTECTED]> wrote:
Hi all;I have a customer who currently uses an application which had becomeslow. After doing some digging, I found the slow query:SELECT c.accno, c.description, c.link, c.category, ac.project_id,p.projectnumber
,a.department_id, d.descri
On 7/28/05, Chris Travers <[EMAIL PROTECTED]> wrote:
Gnanavel S wrote:>>> vacuum & reindex the department and project table as the planner> expects there are 1060 rows but actually returning nothing.I guess I should have mentioned that I have been vacuuming and
reindexing at
On 7/29/05, Karim Nassar <[EMAIL PROTECTED]> wrote:
I ran into a situation today maintaining someone else's code where thesum time running 2 queries seems to be faster than 1. The original codewas split into two queries. I thought about joining them, butconsidering the intelligence of my predecesso
On 7/29/05, Karim Nassar <[EMAIL PROTECTED]> wrote:
On Fri, 2005-07-29 at 09:41 +0530, Gnanavel S wrote:>> Joined:>> test=> explain analyze> test->SELECT cli_name,order.*>
test->
FROM order>
test->
On 9/27/05, Abhijit Menon-Sen <[EMAIL PROTECTED]> wrote:
At 2005-09-27 15:20:05 +0530, [EMAIL PROTECTED] wrote:>> Can anyone please tell/point me where I can get the postgresql system> layout (I've an interest to contribute).
http://www.postgresql.org/developer/codingAnd, in particular:http://www.p
On 9/27/05, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
Have you read the developers FAQ?
Thanks Bruce. I'm going through that.
---
Gnanavel S wrote:> Hi All,>> Can anyone please tell/point me where I ca
Hi All,
Can anyone please tell/point me where I can get the
postgresql system layout (I've an interest to contribute). I would also
like to know the files involved for performing each task ( for eg when
doing a select operation what is exactly happening in postgres along
with the files).
I w